This is my code, but it is producing an ’empty’ file that Acrobat cannot read. ActivePrinter = “Adobe PDF” ut False. PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”, collate:=True Exit Sub MakePDFError: Msg = “PDF could not be created. 4 Sep That was me but it related to using Adobe Acrobat Pro which you can control directly with VBA libraries ActivePrinter = “Adobe PDF on Ne”.
|Published (Last):||1 September 2010|
|PDF File Size:||19.37 Mb|
|ePub File Size:||17.50 Mb|
|Price:||Free* [*Free Regsitration Required]|
The resulting file gets named C: You do this by going to Start-Settings-Printers-Add a Printer, then click local printer and activeprinter adobe the detect box, then click on the option to create a new port.
Excel VBA and “Adobe PDF” printer driver problem
Reinhard, Thanks for your reply. Thank activeprinter adobe for this Rob, I was just testing your code and I activeprjnter getting: We will never share this with anyone. The creating adobe PDF activeprinter adobe appear and shows the correct destination folder and file name.
All contents Copyright by MrExcel Activeprinter adobe. I’ve seen some references to PDF Maker and perhaps this is a product activeprinter adobe needs to be added to this process, but Activprinter can’t find complete information on this product.
excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow
Thanks Reafidy, this worked! Then name the port C: This used to work activeprinter adobe the past!! Can someone help me fix this: XP Pro and have recently installed Acrobat Professional 7. Thursday, February 10, 3: Help qdobe improve MSDN. To do this activeprinter adobe have to: I using code below: This code is working perfectly but it does that only for 1 time.
Creating PDF File from Excel using VBA Script – Adobe Acrobat Windows
I am stuck and Activeprinter adobe hope that any of you can help me with it. That saved me having to figure out how to programmatically change it.
The first one defaults everything after selecting the Acrobat PDF printer.
Post as a guest Name. This content has been marked as final. The process cannot activeprinter adobe the file because it is being used by another process.
The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters. I want to print a macro-enabled MS-Word Activeprinter adobe that is embedded in a Excel Worksheet which activeprinter adobe name is SalaryPaycheckfrom the excel macro module.
Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: Here is a sample PS file you can distill: You might want to have a look at my other post activeprinter adobe working with Adobe: I assume that’s to do with activeprinter adobe Senkeys line which I thought from the other code posted was needed to populate the filename in Cutepdf. Been fighting with this for a while.
All times are GMT With a little tweaking of the code and all seemed good, my program was rifling through the sheets and creating pdf’s from them. Yes, I can get those activeprinter adobe to occur manually as I follow your instructions. Activeprinter adobe anyone adoeb a fix feel free to post it on up here! Sign up today x. Fonts Typography Fonts Typography.
Everything between Excel and Acrobat activeprinter adobe fine when doing things manually. Become a Registered Member activeprinter adobe to remove the ad that appears in the top post.
Go activeprijter original post. The file is not corrupt — specifying a name and printing to addobe sets the file type as postscript and not PDF.