Printing Multiply Workbooks from one Excel Workbook
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 |
Printing Multiply Workbooks from one Excel Workbook
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 |
All times are GMT +1. The time now is 07:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com