Can't copy workseet with embedded chart
I am trying to upgrade from Office 2000 to 2003 and the only real
problem that I have encountered is when I try running one of my
procedures that copies sheets from the activeworkbook into a new
workbook I get the following error.
Automation Error:
The Object Invoked has Disconnected From its Clients
Here is the line it chokes on:
Estimate.Sheets(Array("Cost Sheet Report", "Product Cost Report",
"Tooling", "Package", "Soft Goods", "Softgoods Material", "Purchase
Parts", "Labor")).Copy after:=NewWorkBook.Sheets("Sheet3")
The majority of these sheets have ActiveX controls on them so I assumed
that the problem was due to that. But as I dug a little deeper I
realized the error was due to one of the sheets having a chart on it.
When I delete the chart everything works fine. This only happens in
2003 SP3.
Any ideas?
Thanks,
James
|