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):||6 November 2012|
|PDF File Size:||19.43 Mb|
|ePub File Size:||12.22 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
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.
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?
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.