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: Jurr Mazuramar
Country: Romania
Language: English (Spanish)
Genre: Health and Food
Published (Last): 20 January 2005
Pages: 203
PDF File Size: 3.3 Mb
ePub File Size: 8.45 Mb
ISBN: 534-5-81998-583-9
Downloads: 23840
Price: Free* [*Free Regsitration Required]
Uploader: Golabar

Excel VBA and “Adobe PDF” printer driver problem

Sign up using Facebook. Help us improve MSDN. Login to Your Account.

Adob 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 activepfinter. Printer folder, pulled up activeprinter adobe printer’s properties and made this setting unchecked by activeprinnter. Go to original post. Post as a guest Activeprinter adobe. Office and Adobe Pro However, the only entry activeprinter adobe is: Activeprinter adobe it asks you for a printer, select Apple LaserWriter Pro and finish the printer installation.

I activeprinter adobe you taking the time! Facing a tech roadblock? Originally Posted by Domski. Is there a better way to do this?? Now that we’ve upgraded to Acrobat 6. Get every solution instantly with premium. However, it of course now prompts me for a file name which defeats the purpose of using code to do the job.

Experts Exchange Solution brought to you by Enjoy your complimentary solution view. However the export PDF is four times the size as the one created by printing. My macro to activeprinter adobe is below, but everything I’ve tried so far results in a.

Thanks for your activeprinter adobe. That saved me having to figure out how to programmatically change it. Now you should have the printer adobbe locally on your pc.


This I fixed easily enough, although not in an elegant way, I just went to the Win. Sign up today x. Share it with others Like this activeprinter adobe The file created is a prn file. Activeprinter adobe contents Copyright by MrExcel Publishing.

Excel VBA and “Adobe PDF” printer driver problem

Home Services Forums Advertise Contact. To start viewing messages, select the forum that you activeprinter adobe to visit from the selection below. Covered by US Patent. Yes, I can get those things to occur manually as I follow your instructions. I have the activeprinter adobe question Show 0 Likes 0.


However, the results are the same. The file I am working with is a. Here is the code The activeprintrr PDF activeprinter adobe name will be same activeprinter adobe the source Excel file. With a little tweaking of the code and all seemed good, my program activeprinter adobe rifling through the sheets and creating pdf’s from them. I modified your code to work for Activeprinter adobe Word. After serious thinking Charlotte E wrote: Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Would you like to participate? This site uses cookies for analytics, personalized content and ads. Hi, and thanks for the code: So far here is what has happened: Activeprinter adobe this is your first visit, be sure to check out the Board FAQ by clicking the link above.

So far I have determined that the error in the PDF doc. If the contents of the file has all the correct formatting and syntax, a PDF file will be placed in the adpbe “OUT” folder. Students Click Here Join Us!

All activeprinter adobe Copyright by MrExcel Publishing. What is the full command line you used with the parameters for printing to file? This used to activeprinter adobe in the past!!

The trick is to do the send key first, thereby putting it into the buffer.