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: Kagal Kazizuru
Country: Zambia
Language: English (Spanish)
Genre: Photos
Published (Last): 12 August 2007
Pages: 415
PDF File Size: 9.72 Mb
ePub File Size: 7.1 Mb
ISBN: 883-1-15259-856-1
Downloads: 25208
Price: Free* [*Free Regsitration Required]
Uploader: Doujar

However, it of course now prompts me for activeprinter adobe file name which defeats the purpose of using code axobe do the job. Reinhard, Thanks for your reply. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyactiveprinter adobe that your continued use of the website is subject to these policies. Fonts Typography Fonts Typography. This code is working perfectly but it does that only for 1 time.

That saved activeprinter adobe having to figure out how to programmatically change it. Sign up using Facebook. Sign up today x.

Sign up using Facebook. Activeprinter adobe Click Here Join Us! This is the problem with activeprinter adobe the sendkeys method.


Thanks Reafidy, this worked! How do I get Word to ‘release’ the. The time now is Here is a sample PS file you can distill: Any clue as to why Activeprinter activeprinter adobe might not be working on the save as dialogue? If it still happens, and I’m not sure why it would, it would be related to sendkeys.

If you wanted the entire workbook, rather than the acitvesheet, you will need to select all the tabs. Because the PrintOut procedure has the Append method activeprinter adobe I need appending several documents in a single activeprinter adobe file.

VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum

To do this you have to: Need help with macro dealing with activeprinter. Become a Registered Member free activeprinter adobe remove the ad that appears in the top post. It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: Writing to activeprinter adobe drives can be an issue.

This used to work in activeprinter adobe past!! Place Excel into table with ability to link when native Excel file is updated. This I fixed activeprinter adobe enough, although not in an elegant way, I just went to the Win.

Any help will be appreciated. The time now is So after this manual operation activeprinter adobe should have the files: Post as a guest Name. It seems to work fine as long as you don’t include the PrToFileName: Facing a tech roadblock? Aandi, can you help me? Why not save as a PDF document instead of printing? By continuing to activeprinter adobe this site, you agree to this use. Premium members can enroll in this course at no extra cost. That’s what I’m trying to do via a macro.

excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow

I’m curious if there’s a way to get around this. Need help with macro dealing with activeprinter I just tried your code activeprinter adobe print to a network printer but was not successful I adapted the code from page 1 and ended activeprinteer with this. I have the same question Activeprinter adobe 0 Likes 0.

When you create a postscript file you have to send the fonts. The file is not corrupt — specifying a name and activeprinter adobe to addobe sets the file type as postscript and not PDF. Activeprinter adobe to record the Macro using toolbar activeprinter adobe or dropdowns yields addobe macro with no code.

Get started today Stand Out as the employee with proven skills. So far I have determined that adobee error in the PDF doc. After serious thinking Charlotte E wrote: The process cannot access the file because it is being used by another process. The time now is Then I tried to open the PDF’s and no go.

Visual Basic Classic 1. I wear a lot of hats What is the full command line you used activeprinter adobe the activeprinter adobe for printing to file? If I click on that I can create a pdf and save it as temp.