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: Taramar Tygozahn
Country: Cambodia
Language: English (Spanish)
Genre: Education
Published (Last): 19 June 2006
Pages: 487
PDF File Size: 11.47 Mb
ePub File Size: 2.78 Mb
ISBN: 995-6-87299-807-4
Downloads: 96347
Price: Free* [*Free Regsitration Required]
Uploader: Vudot

avtiveprinter Forums Blogs Articles Groups. Printing to PDF from Macro. That is a different question then. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Behind every great man is a great woman Any way to do this?

VBA Visual Basic for Applications (Microsoft) FAQ

The time now is Philip “I’m almost sure I’m not mad This is because, with the same document opened in Word, I can select the ‘Convert to Adobe PDF’ toolbar button and this creates a temp. It recorded everything up to and including hte printer selection. Please enter a title. Click here for more information on our Cookie Policy and Privacy Policy.

  HP 3551A PDF

Member List Calendar Forum Rules. Using this methodology, I did not require the API code.


How do I code around this so that it works on all computers? Thread Tools Show Printable Version.

It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: Please type your message axobe try again. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

The program then, expecting the temp file to be where it is, sends temp. Storax 4, 3 5 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 Here’s some more background on why and what I am trying to do:. We may share certain information about our users with our advertising and analytics partners. Stack Overflow works best with JavaScript enabled.

excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow

Sign up or log in Sign up using Google. The file created is a prn file. Sign up using Email and Password. How can I be notified when my favorite forums contain new threads?


I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: If this is your first visit, be sure to check out the Board FAQ by activerinter the link above.

VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum

This activity is happening in a program running in a batch mode. Because the PrintOut procedure has the Append method and I need appending several documents in a single pdf file. I have the same question Show 0 Likes 0. I am trying to print to a PDF file from Excel which is relatively adobf to do.

However, it did not record the filename dialog box actions and beyond. 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: All times are GMT I really don’t want activeprintwr have to resort to having the user do this manually.

Related Posts