VBA wont load - Microsoft Office 2013 compatibility problem?

hUbS said:

MS_VBALCID = 3084 or MS_VBALCID = 1033

If you're a US English speaker then those locale IDs should make no difference: you're probably already using locale ID 1033, and you probably don't want a Canadian French (3084) locale.

hUbS said:

The only thing that I am aware of being different on this machine is that it has Office 2013 installed

That's a more likely culprit, since Office installs its own version of VBA, which updates certain core functionality.  That may upset MicroStation VBA.  Does VBA open successfully in one of the Office applications (Word, Excel, Access ...)?

hUbS said:

If I can get macros to work will I be able to use our vba code that connects with Excel considering the new Office 2013 is 64bit?

VBA relies on Microsoft COM for inter-process communication.  COM is 32-bit, and there is no 64-bit version.  MicroStation VBA and Office VBA should continue to communicate.

Bear in mind that Office VBA is version 7 for your version of Office — Microsoft have not released that version to vendors such as Bentley Systems.

I would look to this communities.bentley.com/.../219039.aspx as it is most likely some system change that is causing the problem.

HTH,

I'm having the exact same error on loading VBA.  I didn't start gettting the error until I switched from Windows XP to Windows 7.  I was using Microstation V8i on both machines.   Does anyone have a fix??

Hi John,

Thanks for your reply. I have learnt so much from all of your your valuable posts I just want to shout out a big thanks to you! THANKS!

Unknown said:

Does VBA open successfully in one of the Office applications (Word, Excel, Access ...)?

Yes. I can open the vba editor in Outlook 2013 and I can run code fine.

Unknown said:

COM is 32-bit, and there is no 64-bit version.  MicroStation VBA and Office VBA should continue to communicate.

I see. That's good to know. 

Mike H

Hi Mark,

Unknown said:

communities.bentley.com/.../219039.aspx

This post seems to refer to specific vba projects that do not load. In my case I can't load any vba projects at all. Neither can I create a new one.
So I'm not sure in the value of chasing up the suggestions in that thread.

It looks like my case is not an isolated one . So a clear solution from Bentley I think is in order. 

This is a brand new machine with fresh install of Windows 7 64bit with all updates and Office 2013.

Thanks

Mike H

Hi Everyone,

I installed the prequisite pack of a previous version 'pbda08110706en'

And now everything is working correctly.

I don't know if there can be any adverse consequences of installing this post microstation install but everything appears to be working correctly.

Also. Connecting to Excel 2013 through vba is also working fine.

Yay

Mike H

Ok I'm still having a problem. I had Microsoft Office 2010 on both machines and Microstation V8i.  I changed from XP to Windows 7.  My IT dept has most everything locked down so I can't install a previous version.  Any other suggestions???!  Thanks!

Hi jwl,

I would say your IT Dept should be there to help you resolve the issues. My suggestion is have them get 'Prerequisites for Bentley Desktop Applications' from Bentley Select downloads. Logon to your machine and install it.

Im pretty sure this will fix your problem.

If your machine is locked down I can't see how you can fix your machine without the help of your IT Dept.

Good luck.

Mike H,

I am having the same issue as well. Where would I be able to find this prequisite pack of a previous version 'pbda08110706en' that you are talking about? I have searched the MicroStation support page but I must have over looked it.

Thanks for the help,

Vinny

Hi Vinny,

You can download them from Select Services...

Typically it is listed in the popular download section. Otherwise a search should find it.

Regards,

Mike