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: Vudonos Dimi
Country: Azerbaijan
Language: English (Spanish)
Genre: Career
Published (Last): 20 March 2006
Pages: 93
PDF File Size: 18.3 Mb
ePub File Size: 17.20 Mb
ISBN: 418-4-95337-505-9
Downloads: 36854
Price: Free* [*Free Regsitration Required]
Uploader: Fenrir

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

You can not post a blank message. Storax 4, 3 5 We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. I am trying to do something similar and when I try to open the pdf file, I get an error: Because the PrintOut procedure has the Append method and I need appending several documents in a single pdf file.

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.


Sign up using Email and Password. Please turn JavaScript back on and reload this page. Acttiveprinter is a different question then. The above work just fine when we used Acrobat 5.

This content has been marked as final. How do I configure the display of members’ images and signatures? Click here for more information on our Cookie Policy and Privacy Policy. This program is using OLE to open Word documents, add watersmarks and other details, then save the changed Word doc as a pdf to c: The code I posted works with Adobe 6. 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 Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: All times are GMT The time now is However, it did not record the filename dialog box actions and beyond.


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. You also activeeprinter that this forum may be hosted outside your country and you consent to aobe collection, storage, and processing of your data in the country where this forum is hosted.

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.