Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Workseet Within Same Workbook | Excel Worksheet Functions | |||
Name Embedded Chart | Excel Worksheet Functions | |||
Embedded Chart Versus Chart - ShowDetail Issue | Charts and Charting in Excel | |||
how to copy cell contents from one workseet to another worksheet? | Excel Discussion (Misc queries) | |||
Copy Method of Workseet Class Failed | Excel Programming |