method 'location' of object '_Chart' failed.

Hi,

I'm currently working on a fairly complex VBA project in Excel 2007. Basically though, I'm downloading information from a site, massaging it, creating a lot of graphs, saving them locally, deleting the chart from excel. I then save a copy of the workbook to a local file, clear the Spreadsheet, and then Do the same for information from another site.

When I had all of the code in one Module and ran it as a macro it ran flawlessly.

Now i've put the information into a Class. And am pretty much running the same process via a UserForm.

The problem I have though is that at any point after I execute the code: (and please assume that all variables have been declared, because they have)

Please Login or Register  to view this content.

I can no longer use this statement when moving a chart:

Please Login or Register  to view this content.

Even though I have created the chart and added it to the sheet and peformed various other operations on it by referencing ActiveChart

The Problem seems to lie in the Location method.

If I never "SaveCopyAs" then All the code runs fine, its just that as soon as I SaveCopyAs I can no longer change the location of a Chart:

If I debug the project I receive the error: run-time error 1004 - method 'location' of object '_Chart' failed.
at runtime. (If I then click "End") I get a File/Path Error, and then sometimes Excel crashes.

If I run the project as any user would, I receive the run-time error:

Error -2147417848 (&H80010108): The object invoked has disconnected from its clients.
And then Excel Crashes "Microsoft Office Excel has encountered a problem and needs to close. .... "

Any ideas on how to fix this? I'm assuming that after I saveCopyAs its losing a reference to something, and I've tried many things to fix this problem... all to no avail.

Please help,
Thanks,

You will probably get limit response here, as you did at MSDN, because the problem is specific to your set of files and processes.

The code that is causing you problems does not in itself cause and error.
By that I mean if we take the very small code sample and test it there is no error and things behave as expected.

That would suggest the problem is somewhere else in you complex project.

What you have to do to help us help you is break your processing down so you can post a small example of code and data and still demonstrate the problem. A pain I know but without taking these steps we probably will not be able to suggest anything helpful.

I just built a workbook as per your instructions and it runs without error.

Have you run a detect and repair on your Excel installation?

Here is the workbook I built. See if this errors for you.

I can run from Macro dialog or VBE without failure.
I can step through each line or let it run no failure.

Again, not problems with your example file.

Do you have SP1 installed?

Yes I have Vista.

The SP1 was in reference to Office service pack rather than the OS's

If I get change tonight, before football, I will try XP/XL2007 environment.

Installing SP1 solved the issue.
FINALLY, its so good to know it wasn't a coding problem but a MS problem.

I'm glad MS doesn't make pacemakers.

to quote a co-worker: hey sire , we are experiencing an issue with your pace maker...it needs SP1

thanks for the Help ANDY