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):||15 August 2014|
|PDF File Size:||17.20 Mb|
|ePub File Size:||2.66 Mb|
|Price:||Free* [*Free Regsitration Required]|
Login or Sign Up. Tuberose 2 Results 1 to 10 of Become a Registered Member free to remove the ads that appear in acticeprinter area. The resulting file gets named C: 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.
It is a file formatted to be sent to a printer. WIth Acrobat 9 Pro, this registry setting no longer works as it activeprinterr in 5. Thread Tools Show Printable Version. The challenge seems to be to get the same behavior through the use of a Macro.
Do you see anything that makes you think that it will not?
Creating PDF via Word Macro using Adobe Acrobat | Adobe Community
I can use Application. I want to made file name and path predefined so PrintOut runs quietly. Member List Calendar Forum Rules. I using code below: Share it with others Like this thread?
To start viewing messages, select the forum that you want to visit from the selection below. However, the results are the same.
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
Results 1 to 5 of 5. The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters. What’s the easiest way to become a member and start posting? Actigeprinter above work just fine when we used Acrobat 5.
Runs best on HiVelocity Hosting. If this is your first visit, be sure to check out the Board FAQ by clicking the link above. I am trying to do something similar and when I try to open the pdf file, I get an error: Sign up using Facebook. How should I configure my browser to get the greatest actjveprinter from the Lounge? This activity is happening in a program running in a batch mode.