Printing Multiply Workbooks from one Excel Workbook

H

HCS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Unwanted workbooks on startup 2
Pulling data from one workbook to another one using VBA 0
All Workbook Saved except This Workbook - Part2 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Custom Document Properties in Word documents and Excel workbooks 13
Macro for all Excel Workbooks to print to PDF 2
All Workbook Saved except This Workbook 3

Top