Excel Link Activity - Cannot create ActiveX component

[Bigredh]

All

I have been searching the depths of the forum but cant quite find this error other than in a very old post with minimal response (http://gruss-software.co.uk/forum/viewt ... f=5&t=9890). I recently got a new laptop and when trying to link to Excel, the sheet appears and I can open it OK using "Log Current Prices" but nothing makes it to the sheet as I would expect. This includes trying with a blank workbook. The full error on (including lines around) is as below:

20:57:45:43: Requesting Excel refresh. Origin cell:A1
20:57:45:44: Excel update skipped. First update after market changed.
20:57:46:58: Requesting Excel refresh. Origin cell:A1
20:57:46:89: Severe error:System.Exception: Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.GetObject(String PathName, String Class)
at Betting_Assistant.Excel.getWorksheets() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:line 1621
at Betting_Assistant.Excel.ExcelUpdateThread() in C:\Betting Assistant\Betfair Trading API Beta\Excel.vb:line 1846
20:57:46:90: Excel updated.

This is running using Windows 365, I have also ensured it is not saved on a cloud drive as I know that has caused me issues previously. Finally I have McAffee installed, which I have disabled temporarily in trying to get this to work but had no luck.

I also attempted to register is for the 64 bit by doing the below but again no luck
viewtopic.php?f=5&t=10419

Anyone have any ides to get this working?

Thanks in advanced

[Bigredh]

So it turns out this was my old foe "One Drive", apparently this now owns my desktop file path so it goes "C:\Users\[my user name]\OneDrive\Desktop". I believe this is a feature of using Office 365, it tries to free up as much of your own hard drive as possible... As I have found previously Betting Assistant and cloud drives are not best mates and herein lies the issue.

This was fixed by moving this actually onto my computer, hopefully down the line publishing my stupidity can help someone else out...

Thanks

[MarkRussell]

Hi,

It's a Microsoft security issue due to the way that the software communicates with Excel.
It doesn't work when the Excel file is not on on your local drive.

Regards,
Mark