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: Fenririsar Diramar
Country: Saudi Arabia
Language: English (Spanish)
Genre: Science
Published (Last): 11 December 2016
Pages: 54
PDF File Size: 2.57 Mb
ePub File Size: 10.50 Mb
ISBN: 675-3-88159-188-8
Downloads: 33865
Price: Free* [*Free Regsitration Required]
Uploader: Visar

You don’t have JavaScript enabled. The challenge seems to be to get the same behavior through the use of a Macro.

The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne I can use Application. However, the results are the same.

Because the PrintOut procedure has the Append method and I need appending several documents in a single pdf file.

Printing to PDF from Macro

When I adone a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i. It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: If this is your first visit, be sure to check out the Board FAQ by clicking the link above.


Stack Overflow works best with JavaScript enabled. I just had to dig a little deeper in activepprinter thread. Has anyone found a bullet-proof solution to this? Login or Sign Up. What’s the easiest way to become a member and start posting?

VBA Visual Basic for Applications (Microsoft) FAQ

ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application. I really don’t want to have to resort to having the user do this manually. I’m guessing you’ll need to check if PrimoPDF has similar libraries that you can install or zdobe it can even be controlled with VBA in the first place. Forums Blogs Articles Groups.


The file type must be “. 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. Thank you, in advance, for your help. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

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

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 have the same question Show 0 Likes 0. I want to made file name and path predefined so PrintOut runs quietly.


By using our site, you acknowledge activeprunter you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

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: However, by changing the settings on your Acrobat printer you can remove the dialogue boxes.

The file I am working with is a.

You can not post a blank message. Thread Tools Aftiveprinter Printable Version. For additional details, refer to our Privacy Policy.

This activity is happening in a program running in a batch mode. Do you see anything that makes you think that it will not? 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. Application Dim objDoc As Word.

Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code.