Excel - Automation Error

[richardphunt]

Yesterday sparked up BA and it went through an update routine (haven't used it for a couple of weeks).
Update successful.
New BF login screen. Logged in OK.
Started up my excel workbook with tons of VBA code which is all COM driven
the line that SETs the BA.Com object returns the error ...

Automation Error (no other test just some numbers) if these are relevant I can get these but I am not at that location currently.

I Googled the error and as always there is a number of solutions offered.

The one which I decided to implement was registering the comctl.ocx with regsrv32 this was also successful.
I did though register the 64bit version of the .dll as my machine is a 64 bit running an X86 version of MS Office 2007.

There probably has been a couple of windows updates in the 'downtime' time but I cannot be certain.

Any ideas why this is happening?

[MarkRussell]

Hi,

Please do a manual re-install of Betting Assistant which should fix the problem.

First uninstall via Windows Control Panel and then re-install via the following link:-
http://www.gruss-software.co.uk/Betting_Assistant/Betting_Assistant.msi

Regards,
Mark

[richardphunt]

Thanks for the quick response
OK I will try this later and let you know how it goes

fingers crossed

[richardphunt]

As you would expect the advise to reinstall was SUCCESSFUL!!

Thanks Mark.

Just thought I ought to confirm this as I had forgot to do so earlier in the year