Macro to Save, Print, and Close file
Macro to Save, Print, and Close file
(OP)
I'm looking to see (before I jump on in) if there is a way to have a macro in EXCEL save a file, print the file, and then close the file. Is this something that can be done through a macro?
TIA!
~Boottmills
TIA!
~Boottmills





RE: Macro to Save, Print, and Close file
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Macro to Save, Print, and Close file
~Boottmills
RE: Macro to Save, Print, and Close file
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Macro to Save, Print, and Close file
Link
Print
Link
Close
Link
String those together, try one at a time to get the hang of it and make sure you are getting the desired effect. By default the printout method simply uses the currently selected printer, so depending on what printer you used last it will just print to that (i.e. physical printer or maybe PDF etc) unless you use the ActivePrinter variant. You can always use a userform to select between different printers if desired.
RE: Macro to Save, Print, and Close file