ExecuteExel4 Macro parameters..

T

TKoel

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.
 
J

Jim Cone

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.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top