This might be a shot in the dark as I know it is not a very common use of excel VBA.

My organisation has developed an application within Excel VBA to open CAD drawings by loading files names into a spreadsheet and opening them using TeighaX library.
The library comes from Open Design Alliance Drawings SDK. We then reference these libraries in the VBA development window.

The application has been working well for years and is still working. The problem is that Open Design has updated their libraries and when trying to use the new version the previous code no longer works.

Below is an example of code Where TeighaX is the library, OdaHostApp and AcadApplication are classes of the library and they are used to open the drawing by filename


Please Login or Register  to view this content.

We are getting these errors:


Please Login or Register  to view this content.
and

Please Login or Register  to view this content.