<div>
<div class="content wysiwyg-content">
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&quot; 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? <br />
<br />
This worked fine when the DLL was in VB 2003.<br />
This error is appearing in Excel 2000 but our clients could be using any version of Excel.
</div>
</div>


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.

VB 2005 - Excel COM

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.