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: Voodoogrel Vibei
Country: Malawi
Language: English (Spanish)
Genre: Science
Published (Last): 17 January 2005
Pages: 93
PDF File Size: 16.50 Mb
ePub File Size: 18.50 Mb
ISBN: 143-3-73033-786-1
Downloads: 30451
Price: Free* [*Free Regsitration Required]
Uploader: Tygoshakar

This will make it execute and send the file to the location you want. The time now is Thanks for the help Aandi! Help finding Active printer “on Ne02” also strange in word you application activeprinter adobe set printer without port, but in word, if application activeprinter adobe in code always changes windows default printer as well.

The problem with Excel is that we cannot convert a excel file including several sheets. In place of the Where is the Main Index page of the old Woody’s Lounge?

Help finding Active printer “on Ne02”. Now that we’ve upgraded to Acrobat 6.

Help finding Active printer “on Ne02” – Page 2

The time now is My program should work on different computers, not English only. If you wanted the aciveprinter workbook, rather than the acitvesheet, you will need to select application activeprinter adobe the tabs.

Please let me know activrprinter this works for you! If this is your first visit, be sure to check out the Board FAQ application activeprinter adobe clicking the link above. Aandi, can you help me? I can use Application. How do you build the.

Originally Posted by Hlatigo. You do this by going to Start-Settings-Printers-Add a Printer, then click local printer and uncheck the detect box, then click on the option to create a new port. Login to Your Account. By continuing to use our website, you agree to the use of such cookies. The trick is to do the send key application activeprinter adobe, thereby putting it into the buffer.

Help finding Active printer “on Ne02” Thank you, I used your advice. How should I configure my browser to get the greatest benefits from the Lounge?

To start viewing messages, select the application activeprinter adobe that you want to visit from the selection below. Alternatively, I suppose I could export the registry to a text file and do a application activeprinter adobe, but that seems like a very inelegant solution. All times are GMT. Now you should have the printer setup locally on your pc. The issue I’m having is that I’m not able application activeprinter adobe automate creating the PS file with the PrintOut method due to a box popping up and asking me to input a file name for the pdf file.

But there remains a serious problem.

Even if I give a name application activeprinter adobe the extension. I have written an Access app that automates exporting various queries to Excel, automating charts, etc. There is probably a parameter to use.

Thanks for all the help! We always have to do several PDF for the same excel file.

VBA Visual Basic for Applications (Microsoft) FAQ

Page 2 of 2 First 1 2 Jump to page: Application activeprinter adobe can return the printers collection, but it doesn’t give me the pesky NE number. Click here for more information adboe our Cookie Policy and Privacy Policy. Then name the port C: I just had to dig a little deeper in the thread. Here’s where my VBA skills get stuck. This doesn’t work either, and I am getting frustrated. Page 1 of 2 1 2 Last Jump to page: When it asks you for a printer, select Apple LaserWriter Pro and finish the printer installation.

What is the full command line you used with the parameters for printing to file? Your sample contains a application activeprinter adobe “on”, but it should be localized. Results 11 to 17 of 17 Thread: I turned it into a little function, which works great: I know that i also active;rinter in the french forum for the same topic but is to have best chance to solve my problem o: What’s the easiest way to become application activeprinter adobe member and start posting?