I'm running GEOPAK SS2 (version number in subject line). I got a new computer running Windows 10 a couple months ago, and ever since then I've been unable to run any VBA macros in either GEOPAK or vanilla MicroStation. Our local DOT (Tennessee) also has their own macros that aren't working. When I try to run a macro I get a VBA interface error (see below), so I'm thinking it has something to do with Office 365? Anybody know what could cause this?
The error code I get at the bottom of the MicroStation window is: "VBA interface error: unable to get IDE - 0x8004055b"
If Microsoft Office was installed after MicroStation then it may have introduced an incompatible version of VBA
You need to make sure that when you install you turn UAC User account controls to the lowest setting. If you don't, the registry won't be updated and you won't be able to run vba's.
https://articulate.com/support/article/how-to-turn-user-account-control-on-or-off-in-windows-10
reinstall microstation and then geopak
For more information about the Road and Site design tools, visit the Road and Site design WIKI at: http://communities.bentley.com/products/road___site_design/w/road_and_site_design__wiki
Thanks for the response! I had one of our IT guys help me out with that, but unfortunately it still didn't fix the issue. Also tried running as administrator, as well as running a VBA prerequisite pack, but those didn't work either. He's looking online for more solutions, but wanted me to ask about a couple of options that he's seen:
Microsoft Office/VBA Patch Utility: https://communities.bentley.com/products/microstation/w/microstation__wiki/8872/microsoft-office-vba-patch-utility
Or are there other VBA prereq. packs available that might help?
Do either of those sound like viable solutions? (I hope this question makes sense. I'm a non-computer guy trying to relay what I think just happened, haha)
Thanks!
yes, try it
https://communities.bentley.com/products/microstation/w/microstation__wiki/8872/microsoft-office-vba-patch-utility
Okay, so I told my IT guy to try this, but he said he doesn't have access to the patch. How do we download it? (including what he said in the email just to ensure clarity):
"I found the patch but don’t have access to it. They have it. You may have access but need to find out from them. I don’t have Bentley sign in that works for that ."
Thanks
That was an old patch. I found this one on Microsoft web
https://www.microsoft.com/en-us/download/details.aspx?id=17049
I don't know if it will work. a clean install with the uac off should fix the issue.