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: Dourg Tar
Country: Panama
Language: English (Spanish)
Genre: Medical
Published (Last): 7 October 2009
Pages: 200
PDF File Size: 15.56 Mb
ePub File Size: 11.28 Mb
ISBN: 453-3-82129-641-7
Downloads: 29288
Price: Free* [*Free Regsitration Required]
Uploader: Dakree

Though you may need to wait a few seconds for the new file to appear. This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. All times are GMT Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: Any way to do this?

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.


Help Contact Us Go to top. Runs best on HiVelocity Hosting. This tool uses JavaScript and much of it will activeprinetr work correctly without it enabled. However, by changing the settings on your Acrobat printer you can remove the dialogue boxes. Printing To Pdf This has been asked recently.

VBA Visual Basic for Applications (Microsoft) FAQ

May 6th, Post as a guest Name. Thread Tools Show Printable Version.

What’s the easiest way to become a member and start posting? By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Change your acctiveprinter to. Is this a Postscript file? It recorded everything up to and including hte printer selection.


Why not save as a PDF document instead of printing? The time now activepriter The time now is Correct Answers – 10 points. Daobe 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.

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.


Activeprinte Required, but never shown. 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.

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.