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: Gasho Tukus
Country: Australia
Language: English (Spanish)
Genre: Marketing
Published (Last): 2 August 2018
Pages: 158
PDF File Size: 10.71 Mb
ePub File Size: 13.86 Mb
ISBN: 886-5-45271-386-8
Downloads: 76272
Price: Free* [*Free Regsitration Required]
Uploader: Nikogor

This program is using OLE to open Word documents, add watersmarks and other details, then save the changed Word doc as a pdf to c: To start viewing messages, select the forum that you want to visit from the selection below.

The program then, expecting the temp file to be where it is, sends temp. This doesn’t work either, and I am getting frustrated. Though you may need to wait a few seconds for the new file to appear.

WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5. The above work just fine when we used Acrobat 5. Results 1 to 10 of Forums Blogs Articles Groups.


The time now is I’ve seen some references to PDF Maker and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product. Please enter a title. Where is the Main Index page of the old Woody’s Lounge?

Printing to PDF from Macro

May 7th, It recorded everything up to and including hte printer selection. Ozgrid is Not Associated With Microsoft.

Has anyone found a bullet-proof solution to this? Do you see anything that makes you think that it will not?

You may have to register before you can post: I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF.

All contents Copyright by MrExcel Publishing. We may share certain information about our users with our advertising and analytics partners. How do I code around this so that it works on all computers? The code I posted works with Adobe 6. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.

It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: If this is your first visit, be sure to check out the Board FAQ by clicking the link above.


All times are GMT Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code.


For additional details, refer to our Privacy Policy. This is because, with the same document opened in Word, I can select the ‘Convert to Adobe PDF’ toolbar button and this activeprinyer a temp.

Correct Answers – 10 points. Printing to PDF from Macro I forgot to mention that it is from a command button that it prints to pdf. Member List Calendar Forum Rules. I am trying to do something similar and when I try to open the pdf file, I get an error: The switch to Adobe Acrobat aodbe Pro is necessitated by the need to process documents with Chinese characters.