View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shilpa Shilpa is offline
external usenet poster
 
Posts: 2
Default Instantiating a .Net object in MS Excel Macro

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