COM Automation in MAXSURF: 64-bit and 32-bit compatibility

The last few versions of MAXSURF have been available in 64-bit versions only. Whilst most people are using 64-bit operating systems these days, many are using 32-bit versions of Microsoft Office (I'm still a bit of an Office 2003 die-hard fan myself). There can sometimes be difficulties accessing 64-bit COM automation servers (such as the MAXSURF modules) from 32-bit applications (like Excel 2003 VBA macros). The following video shows how it can be achieved.

If you have any difficulties accessing MAXSURF 64-bit modules from other 32-bit applications, please contact us and we can look for a solution.

To find out more about automation with MAXSURF, please have a look at the on-demand webinar

“Towards Hull Optioneering: Appling MAXSURF Automation”

Offline Despina Karanta Wed, Nov 28 2018 9:33 AM

Hello

Thank you for the video.

I still face the same problem though. I have MAXSURF CONNECT Edition V21.11 64 bit and office 365 Proplus 32 bit. The macros used to work perfectly between MAXSURF 32 bit and these version of office. However, since upgrating to 64 bit MAXSURF, macros are not giving results. Do you have any suggestions?

Thank You!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline pat couser Wed, Nov 28 2018 9:38 AM in reply to Despina Karanta
please send a screen shot of your "references" for the macro to pat(dot)couser(at)bentley(dot)com

I do not have Office 365 in 32 bit to test, is there any reason you are using this rather than the 64-bit version?

https://support.office.com/en-us/article/Choose-between-the-64-bit-or-32-bit-version-of-Office-2dee7807-8f95-4d0c-b5fe-6c6f49b8d261
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Despina Karanta Wed, Nov 28 2018 11:02 AM in reply to pat couser

Thank you!

I sent you the screenshot to have a look
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Dylan Dwyer Wed, Jul 31 2019 1:32 AM

Hi,

I have recently upgraded to V22 Maxsurf and have a large set of excel macros setup with the older 32bit version. I have followed the video to try and link the new reference libraries, but not all reference libraries work. I've only managed to link Maxsurf Resistance - it seems the others Modeler, Stability cant be linked.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline James Clarkson Wed, Jul 31 2019 3:11 AM in reply to Dylan Dwyer

Hi Dylan,

Just to check, you have 32 bit Excel and v22 of MAXSURF which is 64 bit?
At what point does it not work? Are you able to get MAXSURF in the References dialog?

James
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel