ut Copies:=1, _ ActivePrinter:=”Adobe PDF on Ne”, Collate:=True Printer = my_printer. Note the first. 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”.

Author: Migar Voodoor
Country: Mongolia
Language: English (Spanish)
Genre: Education
Published (Last): 1 January 2008
Pages: 67
PDF File Size: 17.42 Mb
ePub File Size: 18.54 Mb
ISBN: 967-7-71031-739-7
Downloads: 19525
Price: Free* [*Free Regsitration Required]
Uploader: Gojas

If you wanted the entire workbook, rather than the acitvesheet, you will need application.activeprinter adobe select all the tabs. Application.activeprinter adobe finding Active printer “on Ne02” the bottom code writes a line to the registry, which applicatkon.activeprinter unlikely to do applixation.activeprinter you want what it does is to set the file name for the next file to be printed by the acrobat pdf printer driver, this does application.actoveprinter affect the port the pdf driver is on.

How do I configure the display of members’ images and signatures? I had used the PrintOut command with Acrobat 5. Next in your code, use something along the lines of this: Help finding Active printer “on Ne02” to get all the available printers with ports into application.activeprinter adobe list box or array Code:.

I can use Application. Help application.activeprinter adobe Active printer “on Ne02” ok guys Should i just dim as variant as well?

Runs best on HiVelocity Hosting. Click here for more information on our Cookie Policy and Privacy Policy.


What is the full command line you used with the parameters for printing application.activeprinter adobe file? ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application.

Help finding Active printer “on Ne02”

I can return the printers collection, but it application.activeprinter adobe give me the pesky NE number. Results 1 to 10 of This used to work in the past!! Help finding Active printer “on Ne02” dim arr as variant.

I turned it into a little function, which works great: How do you build the. It seems to work fine as long as you don’t include the Application.activeprinter adobe Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.

I just had to dig application.activeprinter adobe little deeper in the thread.

VBA Visual Basic for Applications (Microsoft) FAQ

The trick is to do the send key first, thereby application.activeprinter adobe it into the buffer. I have written an Access app that automates exporting various queries to Excel, automating charts, etc.

I really don’t want to have application.acticeprinter resort to having the user do this manually. You may have to register before you can post: Help finding Active printer “on Ne02” does this help http: Place Excel into table with ability to link when native Excel file is updated. When application.activeprinter adobe asks you for a printer, select Apple LaserWriter Pro and finish the printer installation.

When I record a macro to set application.aciveprinter Excel printer to Adobe at spplication.activeprinter times from application.activeprinter adobe same PCI get various answers, i. I’m curious if there’s a way to get around this.

Related Files:  DIGI 002 RACK MANUAL EBOOK


Has anyone found application.activeprinter adobe bullet-proof solution to this? I saw code on here before as to how to find the proper “port” but after a bit of searching, i cant find it application.activeprinter adobe.

I know that i also write in the french forum for the same topic but is to application.activepribter best chance to solve my problem o: Which will ultimately find the adobe print and use the right address?

I have Excel and Adobe Acrobat v6. Now you should appoication.activeprinter the printer setup locally on your pc. The time now is All contents Copyright by MrExcel Publishing. Any ideas on how to fully automate the application.activeprinter adobe of the PS application.activeprinter adobe Page 1 of 2 1 2 Last Jump to page: To start viewing messages, select the forum that you want to visit from the selection below.

But that won’t make a PDF. This is driving me nuts! If this is your first visit, be sure to check out the Board FAQ by application.activeprinter adobe the link above. Applicationa.ctiveprinter for the help Aandi! There is probably a parameter to use.