Macro to Save, Print, and Close file

[boottmills]

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

 

[SkipVought]

What application?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[boottmills]

EXCEL...Sorry...just edited it

~Boottmills

 

[SkipVought]

Have you tried recording a macro?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Agent666]

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

 

[mechedoc]

Are you trying to save, print, and close the Excel workbook or another file (such as a text file)?