ExecuteExel4 Macro parameters..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TKoel - 01 Mar 2008 02:32 GMT

I'm trying to get VBA code to print a worksheet in Excel to a PDF file and
automatically enter the name of the file to be saved. I've seen the
following code - Application.ActivePrinter = "Adobe PDF on Ne10:"
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""Adobe PDF on Ne10:"",,TRUE,,FALSE)"

I'm guessing that all those comas refer to options which may include a file
name.
If so, what is the syntax for adding a string variable in there which would
send the name. Also, I've noticed that the "Ne" designation for my printers
changes from time to time. Is there a way to trap that info so my code can
always be accurate?
Thanks.

Reply to this Message

Jim Cone - 01 Mar 2008 04:53 GMT

My xl4 function reference book lists these options (in order) for the Print command...

range_num (1 prints all pages, 2 prints the specified pages)
from
to
copies
draft
preview
print_what (1 is sheet only, 2 is notes only, 3 is sheet and then notes)
color
feed
quality
vquality

I see nothing that allows a file to be specified. But that doesn't mean it won't work.

Also, it says... Printer.Setup(name of printer) to specify a printer.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"TKoel" wrote in message
I'm trying to get VBA code to print a worksheet in Excel to a PDF file and
automatically enter the name of the file to be saved. I've seen the
following code - Application.ActivePrinter = "Adobe PDF on Ne10:"
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""Adobe PDF on Ne10:"",,TRUE,,FALSE)"

I'm guessing that all those comas refer to options which may include a file
name.
If so, what is the syntax for adding a string variable in there which would
send the name. Also, I've noticed that the "Ne" designation for my printers
changes from time to time. Is there a way to trap that info so my code can
always be accurate?
Thanks.

Reply to this Message

TKoel - 03 Mar 2008 17:25 GMT

Thanks a lot.
That's good info to have.
I'll keep looking for tips on the file name, print que etc..

> My xl4 function reference book lists these options (in order) for the Print command...
>
[quoted text clipped - 13 lines]
>
> Also, it says... Printer.Setup(name of printer) to specify a printer.

Reply to this Message