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”.
|Genre:||Health and Food|
|Published (Last):||6 September 2017|
|PDF File Size:||2.1 Mb|
|ePub File Size:||1.47 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
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
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.