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: Samuro Daizilkree
Country: Congo
Language: English (Spanish)
Genre: Health and Food
Published (Last): 6 September 2017
Pages: 430
PDF File Size: 2.1 Mb
ePub File Size: 1.47 Mb
ISBN: 851-3-61110-858-5
Downloads: 69730
Price: Free* [*Free Regsitration Required]
Uploader: Tugor

This activity is happening in a program running in a batch mode. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

If I click on that I can create a pdf and save it as temp. However, by changing the settings on your Acrobat printer you can remove the dialogue boxes. Username Changing provided by Username Change v1.

The file created is a prn file. For additional details, refer to our Privacy Policy. Thread Tools Show Printable Version.

You can not post a blank message. The file I am working with is a.


Why not save as a PDF document instead of printing? If the contents of the file has all the correct formatting and syntax, a PDF file will be placed in the special “OUT” folder.


However, it did not record the filename dialog box actions and beyond. I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF. I would simply use the following code and tell the adboe to select the PDF printer.

I searched the forum and found a couple questions with no response here and here. The activeprintsr now is It recorded everything up to and including hte printer selection.

Printing to PDF from Macro

The code I posted works with Adobe 6. I using code below: Go to original post. All times are GMT Last edited by Domski; Jan 15th, at The time now is By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. This is driving me nuts! I really don’t want to have to resort to having the user do this manually. I have written an Access app that automates exporting various queries to Excel, automating charts, etc. Sign up or log in Sign up using Google.


If this is your first visit, be sure to check out the Board FAQ by clicking the link above. All times are GMT Is the file you are editing a PostScript file? Well, I need to accomplish this via a macro. Do you see anything that makes you think that it will not?

I can use Application.

Printing to PDF from Macro I forgot to mention that it is from a command button that it prints to pdf. The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne Printing To Pdf This has been asked recently. Hope it helps, Dom Last edited by Domski; Jan 15th, at I have the same question Show 0 Likes 0. Using this methodology, I did not require the API code.

Runs best on HiVelocity Hosting. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.