VBA interface error: unable to run macro

David S said:

I have vbma that gets loaded automatically when I open MicroStation

Do you mean "I have a .mvba that should be loaded automatically" but is not loaded (and I can't load it manually), or do you mean "I have a .mvba that is loaded automatically" but I can't load it manually?

Presumably your VBA project worked at some point in history.  What's changed?

I apologize, I had listed an incorrect workflow in my first post.

The vbma is automatically loaded when I start MS. It is listed in the VBA Project Manager. When I double click on the mvba to run it I get 3 macro options to choose from. I choose one option, then the Microsoft Visual Basic window pops up with a message reading "Compile error: Can't find project or library".

I have use the vba in the past. I recently upgraded to Windows 10 and this is the first time I'm trying to run the vba since upgrading. However, a colleague who still has Windows 8 has the same issue.

David S said:

A colleague who still has Windows 8 has the same issue.

At what point did your macro work?  Was that on Windows 7 — or, did it work on Windows 8 at some stage?

David S said:

Compile error: Can't find project or library

That suggests that the macro may want to use a Windows component that was available when the .mvba was first installed but is absent from Windows 8 and Windows 10.

I did work me we a quite while ago when I had Windows 7. However, it now is not working with 7, 8 or 10.

Hi David,

Please try the steps recommended in the posting below in the order listed to see if it helps resolve your issue.

treeview in vba form

Thank you,
Bob