ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't copy workseet with embedded chart (https://www.excelbanter.com/excel-programming/347544-cant-copy-workseet-embedded-chart.html)

jgeniti

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



All times are GMT +1. The time now is 05:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com