Printing Multiple Workbooks

[Robb]

When clients run my program multiple workbooks (reports) are generated. How can they print all of
these workbooks. They are not saved to the harddrive nor do they want them saved to the harddrive.
Occasionally though they would like to print them and picking them one by one is tedious. I could
write another program or macro but can't Excel do it itself?

I thought I membered reading somewhere that a certain key or combination of keys would add a "Print
all workbooks" type option under the file menu (in the same way that holding Shift in NT's Windows
Explorer would give you the "Open with..." option added to the context menu. Does anyone know of
something like this?

Thanks

 

[Dave Peterson]

I don't think that there's built into excel that does this kind of printing.

And, personally, I wouldn't want a macro that prints all the worksheets in all
my open workbooks. I could have a few workbooks open with lots of worksheets in
each. I wouldn't want a macro to just print everything it found available.

Why not just add a question (a few questions??) to the macro that generates the
reports asking if the reports (and which reports) should be printed?