Copying workbook contents to another workbook
I have an XL97 - XL2003 add-in that needs to copy the entire contents of one
workbook to another workbook without effecting the source workbook. I want to copy all of the sheets, forms, modules, class modules, etc. One obvious solution is to just perform a Save As operation on the source workbook. Unfortunately, if the source workbook wasn't previously saved, then it would be at the end of this operation and that violates my need to not effect the source workbook. Right now, all I'm copying is sheets and I'm doing that by looping throught he source sheets and performing a Copy operation to the target workbook. Anybody have any suggestions on a smarter way to do this? TIA, josh |
Copying workbook contents to another workbook
Thanks Don!
I've been messing around in Excel's object model for years and had never noticed that method. You're my hero. josh |
Copying workbook contents to another workbook
Oh gosh. Never been a hero before.
-- Don Guillett SalesAid Software "Josh Sale" <jsale@tril dot cod wrote in message ... Thanks Don! I've been messing around in Excel's object model for years and had never noticed that method. You're my hero. josh |
All times are GMT +1. The time now is 11:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com