Macro

[thalko]

I have several excel files that I print. I have been asked to create
macro that will allow us to print all these files by just hitting on
button or command (Like Ctrl-X). Can this be done and how?

Thanks,
Ti

 

[Guest]

this can be done with macor record.
tools>macro>record new macro.
do the whole process on record.
then put a button on the sheet.
right click the button>view code
enter this
sub Printmystuff()
call yourrecordedmacro
end sub
you would have to put the print macro
in a master file or in one of the file
you wish to print.

 

[Dave Peterson]

Is it all the files in a folder?

Are the files spread all over creation?

If they're all over the place, you could build a worksheet with the filenames
(including the drive/path) and have a macro open them, print them and close
them.

And did you want to print all the worksheets in each workbook???