Can you access a .NET assembly through COM Interop from Excel 2002

D

DanP

I have created a simple assembly using VB.NET Express (or VB.NET 2005) with
COM Interop and want to instantiate the assembly from VBA using code that
looks like this:

Dim MyPanelObj As MyDebugPanel.MyToolForm

Sub StartMyTool()
If MyPanelObj Is Nothing Then Set MyPanelObj = New MyDebugPanel.MyToolForm
MyPanelObj.startup
End Sub

Using Excel 2003, this works fine. Using Excel 2002, it fails on the line
that creates the object (the New) with the error "Automation Error". Is
there any way that this can be made to work from Excel 2002? Does anyone
know why this *doesn't* work? I have been unable to discover what is wrong.

Any help or advice much appreciated...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference .NET assembly in Access? 3
.Net via COM Interop in VBA 0
Distributing .NET Application Error 0
Weird interop assembly loading problem 2
export excel chart to image from C# without using interop 0
Passing arrays from Excel (VBA) to C# 0
VSTO C# add in Outlook.Appointment error 0
Unable to cast com object (interop) 0

Top