I updated my MS office to 64 bit and when I start SS4 I'm now getting a Microsoft Visual Basic, Class not registered error. Since SS4 is a 32bit program does it need 32 bit MS Office to function properly?
Unknown said:I updated my MS Office to 64 bit and when I start SS4 I'm now getting a Microsoft Visual Basic, Class not registered error
I wrote some comments about bit-ness for those in a similar situation with MicroStation CONNECT.
It's best to match the bit-ness of Office with the bit-ness of MicroStation. However, Bentley Systems let you install both MicroStation V8i (32-bit) and MicroStation CONNECT (64-bit) on the same computer. Microsoft does not let you install both 32-bit and 64-bit versions of Office — installation of the second version will fail.
The problem you observe results, I believe, from Office 64-bit 'stealing' the ActiveX registration signature of VBA 32-bit for its own purposes when it installs VBA 64-bit.
Unknown said:I updated my MS Office to 64 bit
I take my hat off to you! It takes some effort to install MS Office to 64 bit, because Microsoft's installer defaults to 32-bit without offering an option to install 64-bit.
Regards, Jon Summers LA Solutions
old thread I know but maybe it helps others. We recently went to 64bit O365 for a myriad of other reasons and still need to do work in 32 bit Bentley products. From my experience, uninstalling and reinstalling the prereq's "VBAOF11.MSI" and "VBAOF11I.MSI" sorted out the various DOT mvba startup issues.