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: Moshakar Necage
Country: Mayotte
Language: English (Spanish)
Genre: Art
Published (Last): 6 November 2012
Pages: 92
PDF File Size: 19.43 Mb
ePub File Size: 12.22 Mb
ISBN: 941-3-76909-530-1
Downloads: 32811
Price: Free* [*Free Regsitration Required]
Uploader: Manris

Printing to PDF from Macro I forgot to mention that it is from a command button that it prints to pdf. Member List Calendar Forum Rules. Help Contact Us Go to top. Share it with others Like this thread?

All contents Copyright by MrExcel Publishing. I just had to dig a little deeper in the thread.

If I click on that I can create a pdf and save it as temp. For additional details, refer to our Privacy Policy. However, the results are the same. Sign up using Facebook. Username Changing provided by Username Change v1.

Click here for more information on our Cookie Policy and Privacy Policy. I searched the forum and found actvieprinter couple questions with no response here and here Behind every great man is a great woman How can I be notified when my favorite forums contain new threads? The program then, expecting the temp file to be where it is, sends temp. Here’s some more background on why and what I am trying to do: I searched the forum and found a couple questions with no response here and here. You activeprihter not post a blank message.


However, it did not record the filename dialog box actions and beyond. Correct Answers – 10 points. If the contents of the file has all the correct formatting and syntax, a PDF file will be placed in the special “OUT” folder.

Please turn JavaScript back on and reload this page. The challenge seems to be to get the same behavior through the use of a Macro.

Creating PDF via Word Macro using Adobe Acrobat | Adobe Community

Email Required, but never shown. 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 acyiveprinter. Sign up using Email and Password. Hope it helps, Dom Last edited by Domski; Jan activrprinter, at Forums Blogs Articles Groups. Has anyone found a bullet-proof solution to this?

Last edited by Domski; Jan 15th, at 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.


This is driving me nuts!

VBA Visual Basic for Applications (Microsoft) FAQ

This activity is happening in a program running in a batch mode. Where is the Main Index page of the old Woody’s Lounge?

You may have to register before you can post: Here is a sample PS file you can distill: 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 All times are GMT Change your code to. Tuberose 2 The resulting file gets named C: If this is your first visit, be sure to check out the Board FAQ ativeprinter clicking the link above.

I am trying to print to a PDF file from Excel which is relatively simple to do. Post as a guest Name.

activeprihter The time now is Ozgrid is Not Associated With Microsoft. How do I configure the display of members’ images and signatures? That’s what I’m trying to do via a macro.