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”.
|Published (Last):||7 October 2009|
|PDF File Size:||15.56 Mb|
|ePub File Size:||11.28 Mb|
|Price:||Free* [*Free Regsitration Required]|
Has anyone found a bullet-proof solution to this? May 7th, Sign up using Email and Password. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.
By continuing to use our website, you agree to the use of such cookies.
excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow
Sign up or log in Sign up using Google. The program then, expecting the temp file to be where it is, sends temp.
VBA Visual Basic for Applications (Microsoft) FAQ
May 6th, Post as a guest Name. Thread Tools Show Printable Version.
Change your acctiveprinter to. Is this a Postscript file? It recorded everything up to and including hte printer selection.
I am trying to do something similar and when I try to open the pdf file, I get an error: Printing to PDF from Macro. Well, I need to accomplish this via a macro.
I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman 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 can return the printers collection, but it doesn’t give me the pesky NE number. Please type your message and try again. Hope it helps, Dom Last edited by Domski; Jan 15th, at This is because, with the same document opened in Word, I can select the ‘Convert to Adobe PDF’ toolbar button and this aftiveprinter a temp.
This activprinter work either, and I am getting frustrated. Behind every great man is a great woman Username Changing provided by Username Change v1. I have the same question Show 0 Likes 0.
The error handler activeprintfr 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. Member List Calendar Forum Rules. The question asked stackoverflow. When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i.
Philip “I’m almost sure I’m not mad That’s what I’m trying to do via a macro.