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