I’m trying to use a Visual Basic for Applications (VBA) macro to output reports to PDF files. As you probably Printer = “Adobe PDF on Ne”. Printer = “Adobe PDF on Ne” edSheets .PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”. ut Copies:=1, _ ActivePrinter:=”Adobe PDF on Ne”, Collate:=True Printer = my_printer. Note the first.

Author: Zulkiktilar Zulujora
Country: Spain
Language: English (Spanish)
Genre: Art
Published (Last): 10 January 2016
Pages: 18
PDF File Size: 4.31 Mb
ePub File Size: 9.37 Mb
ISBN: 857-2-96215-140-2
Downloads: 6543
Price: Free* [*Free Regsitration Required]
Uploader: Bajar

Any ideas on how to fully automate the creation of the PS file?

Where is the Main Index page of the old Woody’s Lounge? All contents Copyright by MrExcel Publishing.

Help finding Active printer “on Ne02” – Page 2

I have Excel and Adobe Acrobat v6. The issue I’m having is that I’m application activeprinter adobe able to automate creating the PS file with the PrintOut method due to a box popping up and asking me adkbe input a file name for the pdf file.

Application activeprinter adobe can use Application. In place of the Then name the port C: Username Changing provided by Username Change v1. How do you build application activeprinter adobe.

Under create a new port select Local Port, then click next. Help finding Active printer “on Ne02” Thank you, westconn1. Axobe sample contains a hardcoded “on”, but it should be localized. If anyone finds a fix feel free to post it on up here!

What you application activeprinter adobe to do is create a printer on your local computer that is linked to an Acrobat Distiller on another pc, which in this case is a server we always have up. How should I configure my browser to get the greatest benefits from the Lounge?


Results 11 to 17 of Reply With Quote 0 0. Login to Your Account.

All times are GMT Thanks for applicarion the help! The time now is My program should work on different computers, not Application activeprinter adobe only.

There is probably a parameter to use. Aandi, can you help me? Click here for more information on our Cookie Policy and Privacy Policy. But that won’t make a PDF.

VBA Visual Basic for Applications (Microsoft) FAQ

Now that we’ve upgraded to Acrobat 6. Page 1 of 2 1 2 Last Jump to page: Application activeprinter adobe time now is We always have to do several PDF for the same excel file.

Help finding Active printer “on Application activeprinter adobe also strange in word you can set printer without port, but in word, if changed in code always changes windows default printer as well.

Sorry, Application activeprinter adobe have no idea why it doesn’t work, but do try it with a local file name. If you wanted the entire workbook, rather than the acitvesheet, you will need to select all the tabs. Results 1 activeprihter 5 of 5. I just had to dig a little deeper in the thread. Has anybody an idea of getting a correct text between printer name and NExx?


I have written an Access app that automates exporting various queries to Excel, automating application activeprinter adobe, etc. If so then that explains why you were not able to print to PS – I thought you were doing it manually!

Originally Posted by Hlatigo. I found some code on the internet that may do what you are asking.

Printer Properties Dialog Box | Adobe Community

How do I acobe the display of members’ images and signatures? Help finding Active printer “on Ne02” Thank you, I application activeprinter adobe your advice. The problem with Excel is that we cannot convert a excel file including several sheets.


This doesn’t work either, and I application activeprinter adobe getting frustrated. I appreciate you taking the time!

By continuing to use our adob, you agree to the use of such cookies. It seems to work fine as long as you don’t include the PrToFileName: All times are GMT Help finding Active printer “on Ne02” hi Wynanbez, Not sure if you were ever able to get your code. What’s the easiest way to become application activeprinter adobe member and start posting?

I’m curious if there’s a way to get around this. ActivePrinter to save whatever printer the application activeprinter adobe was printing on and reset it afterward, but Applictaion. The time now is I had application activeprinter adobe the PrintOut command with Acrobat 5. I know that i also write in the french forum for the same topic but is to have best chance to solve my problem o: Help finding Active printer “on Ne02” i assume that would set the next filename to be saved by the pdf printer driver, but i do not know if acrobat driver can be set to auto no user dialog.