![]() |
Automation Error when upgrading from 2000 to Office XP
I'm doing some compatibility testing on my VBA code that I wrote in
Office 2000 because we are preparing to rollout Office XP to all of our users. For the most part everything is working fine. But I do have procedure that makes a copy of a workbook and saves it into a new workbook. When I run the line of code below I get and "Automation Error". It should be worth noting that I use a lot of controls throughout the source workbook. Any ideas? Estimate.Sheets(Array("Cost Sheet Report", "Product Cost Report", "Tooling", "Package", "Soft Goods", "Softgoods Material", "Purchase Parts", "Labor")).Copy after:=NewWorkBook.Sheets("Sheet3") Thanks, James |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com