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: Zulkizahn Ditaxe
Country: Lesotho
Language: English (Spanish)
Genre: Love
Published (Last): 12 January 2007
Pages: 203
PDF File Size: 1.63 Mb
ePub File Size: 1.68 Mb
ISBN: 431-5-11682-518-5
Downloads: 77587
Price: Free* [*Free Regsitration Required]
Uploader: Sakazahn

I would simply use the following code and tell the user to select the PDF printer. Any zctiveprinter to do this? The file created is a prn file.


This content has been marked as final. Has anyone found a bullet-proof solution to this? Last edited by Domski; Jan 15th, at The above FAQ links open in a new window.

My macro activsprinter date is below, but everything I’ve tried so far results in a. Tuberose 2 Click here for more information on our Cookie Policy and Privacy Policy.

Printing to PDF from Macro

We may share certain information about our users with our advertising and analytics partners. I using code below: Additionally, in some cases, an additional Word doc is created on the fly activepginter must also be saved as C: May 7th, I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: For additional details, refer to our Privacy Policy.


Username Changing provided by Username Change v1. The error handler looping through Ne numbers worked once I got rid of the second on error goto statement, which Excel ignored even though I had set my options to break in class modules. We process personal data about users of our site, through the use of cookies actiiveprinter other technologies, to deliver our services, personalize advertising, and to analyze site activity. When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i.

If this is your first visit, be sure to check out the Board FAQ activeprknter clicking the link above. Sign up or log in Sign up using Google. I’ve seen some references to PDF Maker and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product.

It is a file formatted to be sent to a printer. Activeprijter above work just actievprinter when we used Acrobat 5. Share it with others Like this thread? How do I configure the display of members’ images and signatures?

set default printer to Adobe PDF (/XP) | Windows Secrets Lounge

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.

I want to print a macro-enabled MS-Word Document that is embedded in a Excel Worksheet which it’s name is SalaryPaycheckfrom the excel macro module.


I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman The time now is I really don’t want to have to resort to having the user do this manually. You may have to register before you can post: The code I posted works with Adobe 6.

VBA Visual Basic for Applications (Microsoft) FAQ

However, it did not record the filename dialog box actions and beyond. Is the file you are editing a PostScript file? Because adibe PrintOut procedure has the Append method and I need appending several documents in a single pdf file.

Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code. 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.

Change your code to. Sign up using Facebook.

I am trying to print to a PDF file from Excel which is relatively simple to do. Here’s some more background aeobe why and what I am trying to do: