I have a VB 2005 DLL which is being accessed from an Excel application using COM. I have registered it on computers using Regasm. In Excel when it creates the object I receive an 'Automation Error" If I create an excel.exe.config to force Excel to use Framework 2.0 it works. I do not want to do this however. Are there any other ways around this?
This worked fine when the DLL was in VB 2003.
This error is appearing in Excel 2000 but our clients could be using any version of Excel.