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):||20 March 2006|
|PDF File Size:||18.3 Mb|
|ePub File Size:||17.20 Mb|
|Price:||Free* [*Free Regsitration Required]|
Please type your message and try again. Become a Registered Member free to remove the ads that appear in thread area.
Printing to PDF from Macro
Behind every great man is a great woman Help Contact Us Go to top.
The suggestion above of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of timing issues. May 6th, Runs best on HiVelocity Hosting. The file created is a prn file.
It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: Username Changing provided by Username Change v1. Though you may need to wait a few seconds for the new file to appear.
I searched the forum and found a couple questions with no response here and here.
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
Please enter a title. It recorded everything up to and including hte printer selection.
Change your code to.