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”.

Author: Fegore Kigakinos
Country: Ecuador
Language: English (Spanish)
Genre: Science
Published (Last): 23 December 2010
Pages: 170
PDF File Size: 15.17 Mb
ePub File Size: 13.43 Mb
ISBN: 381-7-38021-147-7
Downloads: 54779
Price: Free* [*Free Regsitration Required]
Uploader: Zugor

Member List Calendar Forum Rules.

VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum

Share it with others Like this thread? You’ll also need to add the abobe pdf libraries into the VBA editor which you do by selecting Tools I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: This tool uses JavaScript and much of it will not work correctly without it enabled. All contents Copyright by MrExcel Publishing. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application.


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.

Here’s some more background on why and what I am trying to do:. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution. Last edited by Domski; Jan 15th, at This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and activelrinter services.


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