I have an excel spreadsheet that will combine workbook tabs to create an adobe file. The code to set the printer to adobe is. Application. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Printer = “Adobe PDF” doesn’t work. ut _. Copies:=1, ActivePrinter:=”Adobe PDF on Ne”, PrintToFile:=True, Collate:=True, PrToFileName:=sSheetName & sSuffix & “.pdf”.
|Published (Last):||23 December 2010|
|PDF File Size:||15.17 Mb|
|ePub File Size:||13.43 Mb|
|Price:||Free* [*Free Regsitration Required]|
Member List Calendar Forum Rules.
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
The code I posted works with Adobe 6.
Printing to PDF from Macro
I want to print a macro-enabled MS-Word Document that is embedded in a Excel Worksheet which it’s name is SalaryPaycheckfrom the excel macro module. The suggestion above of subsequently passingthe prn file xdobe to a Distiller directory to generate a pdf probably will not work because of timing issues.
Is this a Postscript file? Using this methodology, I did not require the API code. Become a Registered Member free to remove the ads that appear in thread area. Sign up using Facebook. Ozgrid is Not Associated With Microsoft. If this is your first visit, be sure to check out the Board FAQ by clicking the link above. Go to original post. Qdobe you, in advance, for your help.
That’s what I’m active;rinter to do via a macro. I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: The file type must be “.
I turned it into a little function, which works great: This means the macro will run straight through. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5. This is driving me nuts!
VBA Visual Basic for Applications (Microsoft) FAQ
Any way to do this? I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF. If I click on that I can create a pdf and adobw it as temp.
Well, I need to accomplish this via a macro. The time now is