Could Not Load An Object Error - Inventor 2014

[rob.j.ross]

We recently upgraded from Inventor 2011 to 2014.  I am getting the attached error when trying to run VBA macros in version 2014.  I figure that it has something to do with the references for VBA 6 vs VBA 7 but the only one that I am using that is related to forms is Microsoft Forms 2.0 Object Library.  Not sure what is causing this.

[ekinsb · Accepted solution]

I don't believe that Microsoft has provided a 64-bit version of Microsoft Forms.  With Inventor 2014 VBA you must use 64-bit components.

Probably the best alternative is to convert your VBA programs to an add-in.  This will still provide good performance since it's runs in the same process as Inventor but provides much better dialog tools than VBA or what Microsoft Forms provided.

[rob.j.ross]

Thanks Brian.  So you can no longer use any VBA macros with forms in V2014?  I was hoping to avoid having to make all my macros Add-Ins but can if that is now the only option.

[ekinsb]

VBA 7 still supports forms, just the same as it did before.  By including the Windows Forms component into your project you were referencing an additional component that provided additional form capapilities not in standard VBA.  What's not supports is 32-bit components, which in this cases means any of the extra form functionality in the component.  So, depending on what you used in the forms they may or may not need to be redone.