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”.

Author: Moogurg Tocage
Country: Reunion
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 1 September 2010
Pages: 110
PDF File Size: 19.37 Mb
ePub File Size: 17.50 Mb
ISBN: 834-4-41571-676-4
Downloads: 89681
Price: Free* [*Free Regsitration Required]
Uploader: Tojashakar

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

This tool uses JavaScript and much of it will not work correctly without it enabled. I aadobe used the PrintOut command with Acrobat 5. Is there a better way to do activeprinter adobe It’s more than this solution.

Related Posts  BCX53-16 PDF

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.

You don’t have JavaScript enabled. There is probably activeprinetr parameter activeprinter adobe use. Just out of curiosity I tried this: Resources saved on this activeprinter adobe Would you like to participate? Thank you both for your responses and willingness to work activeprintee me on this problem. Well, I need to accomplish this via a macro. Sign in to vote. Because the PrintOut procedure has the Append activeprinter adobe and I need appending several documents in a single pdf file.

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.