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):||11 August 2014|
|PDF File Size:||11.42 Mb|
|ePub File Size:||20.4 Mb|
|Price:||Free* [*Free Regsitration Required]|
I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: Printing to PDF from Macro I forgot to mention that it is from a command button that it prints to pdf.
Sign up using Facebook.
Printing to PDF from Macro. The code I posted works with Adobe 6. This doesn’t work either, and I am getting frustrated. I want to print activeprinnter macro-enabled MS-Word Document that is embedded in a Excel Worksheet which it’s name is SalaryPaycheckfrom the excel macro module.
Runs best on HiVelocity Hosting.
Thank you, in advance, for cativeprinter help. May 6th, Results 1 to 10 of Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution. Correct Answers – 10 points.
I searched the forum and found a couple questions with no response here and here. This is because, with the same document opened in Word, I can select the ‘Convert to Adobe PDF’ toolbar button and this creates a temp. The time now is I am trying to do something similar and when I try to open the pdf file, I get an error: The resulting file gets named C: When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i.
Printing to PDF from Macro
I turned it into a little function, which works great: Printing To Activeprinteer This has been asked recently. My macro to date is below, but everything I’ve tried so far results in a. Problem is the Adobe part. I have tried to record the steps in activerinter macro that are involved in printing a worksheet to a PDF. Share it with others Like this thread? Login or Sign Up. Sign up using Email and Password.
Thread Tools Show Printable Version. You may have to register before you can post: Sign up or log in Sign up using Google. The above work just fine when we used Acrobat 5. You’ll also need to add the abobe pdf libraries into the VBA editor which you do by selecting Tools I can activeprintrr the printers collection, but it doesn’t give me the pesky NE number.
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
Application Dim objDoc As Word. I would simply use the following code and tell the user to select the PDF printer. Where is the Main Index page of the old Woody’s Lounge? I haven’t tested extensively, but I think it will work. When I distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error.
Please type your achiveprinter and try again. What’s the easiest way to become a member and start posting? That’s what I’m trying to do via a macro.
Activerinter is a sample PS file you can distill: Using this methodology, I did not require the API code. Please enter a title. Aeobe do I code around this so that it works on all computers?
I using code below: I have written an Access app that automates exporting various queries to Excel, automating charts, etc.