Instantiating a .Net class in MS Excel Macro

S

Shilpa

Hi,

I am trying to instantiate a .Net class in the VB editor of MS Excel
(PE 2003) Macros.
I have added the reference to the tlb of the .Net (TestProject)
project.
I am able to create the object as
dim x as TestProject.TestClass
But the following line of code is causing a runtime error.
set x = new TestProject.TestClass

I am getting the following error
"Automation error
The system cannot find the file specified."

Please help.

Regards,
Shilpa
 

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

Instantiating a .Net object in MS Excel Macro 0
Problem in macro referencing a Com Class built on Dotnet 2.0 2
Automation Error: The system cannot find file specified 3
Linking data in MS Word into Excel 5
Referencing .Net Remoting Services project in MS Excel Macro 0
microsoft.office.interop.msproject error 0
Immediate Fail: Launch Excel via Interop 0
.net dll - error 429 ActivX component cannot create object 0

Top