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