ACTIVEPRINTER ADOBE PDF
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):||19 June 2006|
|PDF File Size:||11.47 Mb|
|ePub File Size:||2.78 Mb|
|Price:||Free* [*Free Regsitration Required]|
VBA Visual Basic for Applications (Microsoft) FAQ
Member List Calendar Forum Rules. Using this methodology, I did not require the API code.
How do I code around this so that it works on all computers? Thread Tools Show Printable Version.
It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: Please type your message axobe try again. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.
excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow
Sign up or log in Sign up using Google. The file created is a prn file. Sign up using Email and Password. How can I be notified when my favorite forums contain new threads?
I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: If this is your first visit, be sure to check out the Board FAQ by activerinter the link above.
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
This activity is happening in a program running in a batch mode. Because the PrintOut procedure has the Append method and I need appending several documents in a single pdf file. I have the same question Show 0 Likes 0. I am trying to print to a PDF file from Excel which is relatively adobf to do.
However, it did not record the filename dialog box actions and beyond. This program is using OLE to open Word documents, add watersmarks and other details, then save the changed Word doc as a pdf to c: All times are GMT I really don’t want activeprintwr have to resort to having the user do this manually.