ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Instantiating a .Net object in MS Excel Macro (https://www.excelbanter.com/excel-programming/358567-instantiating-net-object-ms-excel-macro.html)

Shilpa

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



All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com