VBA interface error: failed creating the comp manager - 0x80040583

Kieran Rutter said:

am having issues with a macro that was previously developed in Microsation Powerdraft v8i

Can you run other VBA macros in MicroStation CONNECT?  That is, is your problem specific to your old macro or a general VBA problem?

Jon Summers said:

am having issues with a macro

Can you do something really simple...

• use the VBA Project Manager to create a new project YourProjectName
• write a simple Main function in the IDE

Public Sub Main ()
  Const ProcedureName As String = "Main"
  Debug.Print ProcedureName
  ShowMessage ProcedureName, ProcedureName
End Sub

Run that in the IDE in using debug, then run from the key-in window using vba run [YourProjectName].Main

Jon Summers said:

am having issues with a macro

Can you do something really simple...

• use the VBA Project Manager to create a new project YourProjectName
• write a simple Main function in the IDE

Public Sub Main ()
  Const ProcedureName As String = "Main"
  Debug.Print ProcedureName
  ShowMessage ProcedureName, ProcedureName
End Sub

Run that in the IDE in using debug, then run from the key-in window using vba run [YourProjectName].Main

Hi Jon,

I can't even get microstation connect to create a new vba project for some reason, still having the interface error come up.

Kieran Rutter said:

I can't even get microstation connect to create a new vba project for some reason, still having the interface error come up

Occasionally an automated Windows update breaks VBA.  Try repairing your MicroStation installation.

Also, If you install Microsoft Office 32-bit after Microstation, it will break vba.  Repairing Microstaton or reinstalling VBA 64-bit would help.

--Robert

Turns out this was the culprit. I had an older version of Access Database which prevented a 64-bit office being installed. Got rid of that and got everything updated to 64-bit and we are now fully functioning with VBA.