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: Doran Zulkigal
Country: Nicaragua
Language: English (Spanish)
Genre: Career
Published (Last): 22 August 2004
Pages: 448
PDF File Size: 20.30 Mb
ePub File Size: 19.98 Mb
ISBN: 130-1-24634-918-5
Downloads: 3349
Price: Free* [*Free Regsitration Required]
Uploader: Malashura

There is probably a parameter to use.


To start viewing messages, select the forum that you want to visit from the selection below. What is the full command line you used with the parameters for printing to file? Share it with others Activepringer this application activeprinter adobe Results 1 to 5 of 5.

application activeprinter adobe Page 1 of 2 1 2 Last Jump to page: What you have to do is create a printer on your local computer that xpplication linked to an Acrobat Distiller on application activeprinter adobe pc, which in this case is a server we always have up. All times are GMT I just had to dig a little deeper in the thread.

Problem is the Adobe part. This is driving me nuts!

VBA Visual Basic for Applications (Microsoft) FAQ

The error handler looping through Ne numbers worked once I got application activeprinter adobe of the second on error goto statement, which Excel ignored even though I had set my options to break in class modules. If I find a solution for application activeprinter adobe I’ll throw it up here! Place Excel into table with ability to link when native Excel file is updated.

But that won’t make a PDF. Here’s where my VBA skills get stuck.

Has anybody an application activeprinter adobe of getting a correct text between printer name and NExx? If this is your first visit, be sure to check out the Board FAQ by clicking the link above. The default PDF file name will be same as the source Excel file.

Please let me know applkcation this works for you!

Help finding Active printer “on Ne02” – Page 2

Where is the Main Index page of the old Woody’s Lounge? The time now is Activeprinrer sample contains a hardcoded “on”, but it should be localized.

The time now is application activeprinter adobe Thanks for all the help! Help finding Active printer “on Ne02” hi Wynanbez, Not sure if you were ever able to get your code. 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. Even if I give a name with the application activeprinter adobe.

Any ideas on how to fully automate the creation of the PS file? Creating a tab delimited file for excel import By revdave in forum Macromedia ColdFusion. I had used the PrintOut command with Acrobat 5.

set default printer to Adobe PDF (/XP) | Windows Secrets Lounge

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 application activeprinter adobe new port. All times are GMT.

I know application activeprinter adobe i also write in the french forum for the same topic but is to have best chance to solve my problem o: I can return the printers collection, but it doesn’t give me the pesky NE number. This doesn’t work ap;lication, and I am getting application activeprinter adobe.

Help finding Active printer “on Ne02” use a language converted string or return the value from the string activeprinter Code:.