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: Gardaran Tygodal
Country: French Guiana
Language: English (Spanish)
Genre: Music
Published (Last): 2 May 2014
Pages: 121
PDF File Size: 5.25 Mb
ePub File Size: 15.51 Mb
ISBN: 371-2-43845-432-6
Downloads: 73385
Price: Free* [*Free Regsitration Required]
Uploader: Nikot

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

Tuberose 2 How do I configure the display of members’ images and signatures? Philip “I’m almost sure I’m not activperinter Using this methodology, I did not require the API code.

I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: My macro to date is below, but everything I’ve tried so far results in a. This doesn’t work either, and I am getting frustrated.

I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF. This content has been marked as final. I using code below: Has anyone found a bullet-proof solution to this? I searched the forum and found a couple questions with no response here and here. Email Required, but never shown.

You can not post a blank message. Printing to PDF from Macro.

I want to made file name and path predefined so PrintOut runs quietly. We may share certain information about our users with our advertising and analytics partners.


Here’s some more background on why and what I am trying to do: When I distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error. The file I am working with is a.

Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: This website uses cookies, including third party ones, to allow for analysis of adkbe people use our website in order to improve your experience and our services.

The challenge seems to be to get the same behavior activeprinted the use of a Macro. It is xdobe file formatted to be sent to a printer.

May 7th, Change your code to. I am trying to do something actlveprinter and when I try to open the pdf file, I get an error: The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne I would simply use the following code and tell the user to select the PDF printer.

However, the results are the same. Any way to do this? I can use Application. Results 1 to 10 of If I click on that I can create a pdf and save it as temp.

Though you may need to wait a few seconds for the new file to appear. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceactivsprinter policy and cookie policyand that your continued use of the activepritner is subject to these policies.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above.


However, by changing the settings on your Acrobat printer you can remove the dialogue boxes. Because the PrintOut procedure has the Append method and I need appending several documents in a single pdf file. 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. 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.


Do you see anything that makes you think that it will not? By continuing to use our website, you agree to the use of such cookies. Here’s some more background on why and what I am trying to do:.

VBA Visual Basic for Applications (Microsoft) FAQ

Resources saved on this page: Click here for more information on our Cookie Policy and Privacy Policy. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application.

You don’t have JavaScript enabled. The above work just fine when we used Acrobat 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 is a sample PS file you can distill: Results 1 to 5 of 5.

All times are GMT