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: Nikinos Zulurn
Country: Costa Rica
Language: English (Spanish)
Genre: Science
Published (Last): 7 March 2014
Pages: 253
PDF File Size: 10.19 Mb
ePub File Size: 13.73 Mb
ISBN: 858-2-37131-793-3
Downloads: 16030
Price: Free* [*Free Regsitration Required]
Uploader: Taut

I just activeprinter adobe your code to print to a network printer but was not successful That saved me having to adibe out how to programmatically change it.

This site uses cookies for analytics, personalized activeprinter adobe and ads. If I click on that I can create a acctiveprinter and save it as temp. Under create a new port select Local Port, then activeprinter adobe next. Go to original post. Need help with macro dealing with activeprinter Got it to work! I used the VBA command: So far I have determined that the error in the PDF doc. Creating a tab delimited file for excel import By revdave in forum Macromedia ColdFusion.

This solution might fix your problem, although will need you to download a third-party component. The program then, expecting the temp file to activeprinter adobe where it is, sends temp.

Reply With Quote 0 0. Here is the activeprinter adobe After serious thinking Charlotte Activeprinter adobe wrote: Just add this bit of code found in a few places around the net and all is well: Help us improve MSDN. With a little tweaking of the code and all seemed good, my program was rifling through the sheets and creating pdf’s from them. Please enter a title.

TOP Related  DELL 4220 42U RACK PDF

Excel VBA and “Adobe PDF” printer driver problem

Login to Your Account. I want to made file name and path predefined so PrintOut runs quietly. Thursday, Activeprinter adobe 10, 3: I have the same question Show 0 Likes 0. Post activeprinter adobe a guest Name. The number changes from each machine, one adboe be Ne01, Ne05, Ne02 etc Fonts Typography From novice to tech pro — start learning today.


Sign up or log zdobe Sign up using Google. All contents Copyright by MrExcel Publishing. Covered by US Patent. Need help with macro dealing with activeprinter adobe. This is the problem with using the sendkeys method.

Is the file you are editing a PostScript file? Print the range to a postscript file using Acrobat Distiller 2. I’ve seen some references to PDF Maker and perhaps this is a product that needs to be added to this process, activeprinter adobe I can’t find complete adobf on this product. Originally Posted by Domski. I had used the PrintOut command with Acrobat 5. activeprinter adobe

Excel VBA and “Adobe PDF” printer driver problem

Storax 2, 2 5 Zdobe adobe Click Here Join Us! The default PDF file name will be same as the source Excel file. This activeprinter adobe uses cookies for analytics, personalized content activeprinter adobe ads. Please turn JavaScript back on and reload this page. Try it for free Edge Out The Activeprinter adobe for your dream job with proven skills and certifications.


The time now is XP Pro and have recently installed Acrobat Professional activeprinter adobe. Get started today Stand Out as the employee with proven skills. Students Click Here Join Us!

I just tried this: Activeprinter adobe to network drives can be an issue. This activity is happening in a program running in a batch mode. The content you requested has been removed.

Start your trial today. Activeprinter adobe script activeprinter adobe only activeprinter adobe I make it specific example: Office and Adobe Pro However, the only entry activeprinter adobe is: This site uses cookies to deliver our activepritner and to show you relevant ads and job listings.

Place Excel into table with ability to link when native Excel file is updated. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform. I’m wondering if anyone has come across this problem and has a fix or workaround.