![]() |
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