ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automation Error when upgrading from 2000 to Office XP (https://www.excelbanter.com/excel-programming/347101-automation-error-when-upgrading-2000-office-xp.html)

jgeniti

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