Hello,

I have the requirement to print off a certain sheet (e.g. could be OCT04 or
NOV04) in a number of workbooks all at the same time. i would like to be
able to do this from one Excel document using VBA. I know how to write the
code to loop through the excel sheets and open them up one at a time and
print off the page. However is it possible to simply tell Excel to Print a
worksheet in another workbook without opening it. Much the same way as you
can referance another workbook in a formula.

I am using Excel 2k

Any help would be greatly appreciated

Graham

A single worksheet; I believe not.

--
Regards,
Tom Ogilvy

"HCS" wrote in message
...
Hello,

I have the requirement to print off a certain sheet (e.g. could be OCT04
or
NOV04) in a number of workbooks all at the same time. i would like to be
able to do this from one Excel document using VBA. I know how to write the
code to loop through the excel sheets and open them up one at a time and
print off the page. However is it possible to simply tell Excel to Print a
worksheet in another workbook without opening it. Much the same way as you
can referance another workbook in a formula.

I am using Excel 2k

Any help would be greatly appreciated

Graham