We are writing a VBA macro on a system loaded with Office 2003 that accesses an Excel spreadsheet.
When we take this macro to a machine that is running an earlier version of Excel we receive an error that states that it cannot find the Excel Object Library.
Tracing the error shows that versions of Excel prior to Office 2003 access an object library with the extension .olb. The reference for Excel 2003 is to excel.exe. Is there a way to make this VBA macro ‘backward compatible’ at runtime?
The program that is running the VBA macro is Autodesk Actrix Technical 2000.
