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: Taurg Arajora
Country: Eritrea
Language: English (Spanish)
Genre: Art
Published (Last): 15 August 2014
Pages: 311
PDF File Size: 17.20 Mb
ePub File Size: 2.66 Mb
ISBN: 683-9-49712-159-8
Downloads: 28464
Price: Free* [*Free Regsitration Required]
Uploader: Mikadal

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.


This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. Stack Overflow works best with JavaScript enabled. Is the file you are editing a PostScript file?


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

Please turn JavaScript back on and reload this page. When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i.

How do I configure the display of members’ images and signatures? May 7th, I am trying to print to a PDF file from Excel which is relatively simple to do. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

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.