Automation Error when upgrading from 2000 to Office XP

J

JGeniti

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
 

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

Can't copy workseet with embedded chart 0
Copy worksheet without triggering events 2
Excel 2007 -- Automation Error 14
Upgrading from Office XP/2002 to Office 2003 6
Windows XP Office 2003 Run-time error '9' 2
Run-time error '-2147221080 (800401a8)': Automation error 1
Affect on macros when upgrading from Office 2000 to 2003. 3
Email Upgraded from Office 2000 to Office 2007 2

Top