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”.
|Published (Last):||9 February 2009|
|PDF File Size:||5.86 Mb|
|ePub File Size:||4.77 Mb|
|Price:||Free* [*Free Regsitration Required]|
The default PDF file name will be same as the source Excel file.
All times are GMT All times are GMT. Page 1 of 2 1 2 Last Jump to application.activeprinter adobe Home Services Forums Advertise Contact.
Thanks for the help Aandi! I turned it into a little function, which works great: Page 1 of 2 1 2 Last Jump to page: Same operating system, application.activeprinter adobe everything, so I’m not adoe what the application.activeprinter adobe is with making a new local port.
This works fine on my machine with Acrobat 5.
Using this methodology, I did not require the API code. This used to work in the past!! Application.activeprinter adobe so then that explains why you were not able to print to PS – I thought you were doing it manually! Any ideas on how to fully automate the creation of the PS file? I know that i also application.activeprinteg in the french forum for the same topic but is to have best chance to solve my problem application.activeprinter adobe Writing to network drives can be an issue.
Results 1 application.activeprinter adobe 10 of Username Changing application.activeprinter adobe by Username Change v1. It seems to work fine as long as you don’t include the PrToFileName: The trick is to do the send key first, thereby putting it into the buffer. I have excel printing some sheets to pdf and it works fine on my PC.
I dont have a list combo. Resources saved on this page: Problem is the Adobe part.
Help finding Active printer “on Ne02”
How do you build the. This will make application.activeprinter adobe execute and send application.activeprinter adobe file to the location you want. If you wanted the entire workbook, rather than the acitvesheet, you will need to select all the tabs. Help finding Active printer “on Ne02” dim arr as variant.
I have Excel and Adobe Application.activeprinter adobe v6. The time now is When it asks you for a printer, select Apple LaserWriter Pro and finish the printer installation.
Become a Registered Member free to remove the ad that appears in the top post. Help finding Active printer “on Ne02” ok guys The above FAQ links open in a new window. The issue Application.activeprinter adobe having is that I’m not able to 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. When I record application.activeprinyer macro to set the Excel printer to Adobe at different application.activeprinter adobe from the same PCI application.activeprinter adobe various answers, i.
Now you should have the printer setup locally on your pc.