Getting traded values off a chart...

[GaryRussell]

I'm afraid I'm out of ideas. You could try uninstalling and re-installing in case it's not registered the COM dll correctly, but if that doesn't work then I'm at a loss.

[JayBee]

The Excel Error Log says...

Excel Action - Excel Update

Error Message - Excel Thread is Busy

[GaryRussell]

That's nothing to do with the COM interface I'm afraid. It's normal for that to appear occassionally when Excel is busy. BA automatically retries when it encounters this error. This error message is only a problem when it appears constantly and Excel is not being updated at all.

[JayBee]

What does the error code...

Run-time error '-2147024894 (80070002)':

File or assembly name BettingAssistantCom, or one of its dependencies, was not found.

...mean?

[GaryRussell]

What does the error code...

Run-time error '-2147024894 (80070002)':

File or assembly name BettingAssistantCom, or one of its dependencies, was not found.

...mean?

What it says really, it cannot find the .dll required for the COM interface. I don't know why in your case though because we've already been through the possible solutions.

[JayBee]

Well, I've been away coding with the Free BetFair API and now wish to meld what I've created there with what you have.

I got the spreadsheet to work but only after removing all the code from the subroutine in the VBA.

I will gradually add code to see where the offending line is and let you know.