Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Workseet Within Same Workbook lehigh46 Excel Worksheet Functions 1 August 21st 07 12:53 PM
Name Embedded Chart Jen[_4_] Excel Worksheet Functions 1 June 27th 07 02:18 PM
Embedded Chart Versus Chart - ShowDetail Issue [email protected] Charts and Charting in Excel 1 May 14th 06 04:11 PM
how to copy cell contents from one workseet to another worksheet? James Excel Discussion (Misc queries) 1 January 21st 06 09:12 PM
Copy Method of Workseet Class Failed Tom Kosensky Excel Programming 1 July 15th 03 09:54 AM


All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"