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):||25 September 2014|
|PDF File Size:||17.54 Mb|
|ePub File Size:||4.82 Mb|
|Price:||Free* [*Free Regsitration Required]|
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 really don’t want to have to adboe to having the user do this manually. Any way to do this? I haven’t tested extensively, but I think it will work. How do I configure the display of members’ images and signatures?
I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: I using code below: You can not post a blank message.
Application Dim objDoc As Word.
Printing to PDF from Macro
VBA Visual Basic for Applications (Microsoft) FAQ
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
Email Required, but never shown. Username Changing provided by Username Change v1. The question asked stackoverflow. Become a Registered Member free to remove the ads that appear in thread area.
Go to original post. Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman You may have to register before actkveprinter can post: I’ve seen some references to Activepriner 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.
The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne All times are GMT Printing to PDF from Macro. What’s the easiest way to become a member and start posting? All contents Copyright sdobe MrExcel Publishing. This doesn’t work either, and I am getting frustrated. The file type must be “. May 7th, Runs best activeprnter HiVelocity Hosting. I have Adobe Acrobat 8 and Excel Post as a guest Name.
Problem is the Adobe part.