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):||12 January 2007|
|PDF File Size:||1.63 Mb|
|ePub File Size:||1.68 Mb|
|Price:||Free* [*Free Regsitration Required]|
I would simply use the following code and tell the user to select the PDF printer. Any zctiveprinter to do this? The file created is a prn file.
This content has been marked as final. Has anyone found a bullet-proof solution to this? Last edited by Domski; Jan 15th, at The above FAQ links open in a new window.
Printing to PDF from Macro
If this is your first visit, be sure to check out the Board FAQ activeprknter clicking the link above. Sign up or log in Sign up using Google. I’ve seen some references to PDF Maker and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product.
It is a file formatted to be sent to a printer. Activeprijter above work just actievprinter when we used Acrobat 5. Share it with others Like this thread? How do I configure the display of members’ images and signatures?
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
The suggestion above of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of timing issues.
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 searched the forum and found a couple questions with no response here and here Behind every great man is a great woman The time now is I really don’t want to have to resort to having the user do this manually. You may have to register before you can post: The code I posted works with Adobe 6.
VBA Visual Basic for Applications (Microsoft) FAQ
However, it did not record the filename dialog box actions and beyond. Is the file you are editing a PostScript file? Because adibe PrintOut procedure has the Append method and I need appending several documents in a single pdf file.
Change your code to. Sign up using Facebook.
I am trying to print to a PDF file from Excel which is relatively simple to do. Here’s some more background aeobe why and what I am trying to do: