using The COM interface

[Hovrin]

Hi All,

Checked all the Help files and searched the Forum but I can't find the answer to this one. I have just returned to BA after a couple of years doing other things and when trying to use a VBA script which I used to use before I get a COM interface error.

The code is :
If ba Is Nothing Then
Set ba = New BettingAssistantCom.ComClass <<-- The error occurs here
End If

The error is :
Runtime Error - 2147221164
Class Not Registered

I have got BettingAssistantCom referenced in the editor Tools/References anf the code used to run with no problems so has there been a change in BA that I can't find?

Thanks in anticipation.

Keith

[Hovrin]

OK, I sorted it by uninstalling Office 2016 64 bit and installing Office 2016 32 bit.

Does this mean that the BettingAssistantCom class is 32 bit only and cannot be used on 64 bit systems ????

[osknows]

You can register it for 64bit by opening the Command Prompt (Admin) and type the following two commands

i) cd C:\Windows\Microsoft.NET\Framework64\v4.0.30319
ii) regasm /codebase "c:\program files (x86)\Betting Assistant\BettingAssistantCom.dll"

The Command Prompt (Admin) is found by right clicking the Windows start button. If the powershell is showing instead see this link to restore it https://support.microsoft.com/en-us/hel ... and-prompt

[Hovrin]

Many thanks for that Osknows.

It has worked a treat. I shall make a note of it so that I can use it in future.

Keith