View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jgeniti jgeniti is offline
external usenet poster
 
Posts: 30
Default 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