can anyone help with the code for creating a aut print macro...

[des-sa]

please can anyone help me wih code for creating a macro that will
automatically print 2 copies and save the document when triggered. would it
be possible to add to that same macro, code that will auto close current
workbook and open a new template?
thank you

 

[Dave Peterson]

You can start by recording your own macro.

Open the file that should be printed, saved, and closed.
With that workbook active, hit:
Tools|Macro|Record New Macro
(xl2003 menus)

But record the macro into a new workbook--not this workbook and not personal.

Then do everything you want.
Print twice
save and close the document
and start a new workbook based on your template.

Then stop recording.

Activate the workbook with the newly recorded macro and save it as a nice name.

Next time you need this kind of stuff, open this macro workbook.
Make sure that the workbook that should be printed, saved, closed is active and
hit:
Tools|Macro|Macros...
Select the recorded macros and click Run