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):||2 June 2013|
|PDF File Size:||18.23 Mb|
|ePub File Size:||13.3 Mb|
|Price:||Free* [*Free Regsitration Required]|
Become a Registered Member free to remove the ads that appear in thread area.
If this is your first visit, be sure to check out the Board FAQ by clicking the link above. You may have to register before you can post: To start viewing messages, select the forum that you want activeprintre visit from the selection below.
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
It recorded everything up to and including hte printer selection. However, it did not record the filename dialog box actions and beyond. Any way to do this?
I have Adobe Acrobat 8 and Excel I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman However, by changing the settings on your Acrobat printer you can remove the dialogue boxes.
This means the macro will run straight through. Though you may need to wait a few seconds for the new file to appear. Philip “I’m almost sure I’m not mad You’ll also need to add the abobe pdf libraries into the VBA editor which you do by selecting Tools Hope it helps, Dom Last edited by Domski; Jan 15th, at Printing to PDF from Macro I forgot to mention that it is from a command button that it prints to pdf.
Thank you for your help. The code I posted works with Adobe 6. I’m guessing you’ll need to check if PrimoPDF has similar libraries that you can install or if it can even be controlled with VBA in the first place. Dom “May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch Share it with others Like this thread? Results 1 to 10 of Printing to PDF from Macro.
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
Thread Tools Show Printable Version. I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF.
I searched the forum and found a couple questions with no response here and here. Behind every great man is a great woman Last edited by Domski; Jan 15th, at I am trying to do something similar and when I try to open the pdf file, I get an error: All times are GMT The activerpinter now is Resources saved on this page: All contents Copyright by MrExcel Publishing.