Click here to Skip to main content
15,885,921 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Hi frds,
I create a Dll by building a class library in the Visual Studio 2005.I call a function of that Dll in the Excel's Macro.
When I Executing Macro then function of that DLL calls and it gave Error Code 429.
I want to Debug the Code of that DLL, when DLL's Function Excuting in Macro.
What settings are Required to Debug the Code of the Dll in visual studio or additional changes required?.I researched alot about it but did not got any success.
its very urgent!!

Thank you..
Posted

Error 429 is 'ActiveX Component Can't Create Object'

Your Excel code cannot create an instance of the COM component - Did you definitely create the class library as a COM object? You cannot just access a .Net DLL from COM without a bit of plumbing to make it accessible.

Building COM Objects in C#[^]

You should then have a ProgID[^] for your DLL, which you can use to create instances.
 
Share this answer
 
Comments
nigam.anant 20-Mar-12 8:59am    
Thanks for feed back.
I create a Class Library as a com Object.I register the DLL in the GAC using Gacutil.exe and also register using Regasm.exe.I also create a com enabled DLL.when i build the Dll then there is a tlb file also generated which reference i gave in the excel.
I am using 64 bit Operating System and 64 bit MS Office Excel.
I Want to debug the DLL is it posible?
The DLL you created, first needs to be installed in the global assembly cache(The dll needs to be shared). It should also be a COM enabled DLL, so you need to create a COM object to access a private .NET DLL.


Thanks
 
Share this answer
 
Comments
nigam.anant 20-Mar-12 8:57am    
I register the DLL in the GAC using Gacutil.exe and also register using Regasm.exe.I also create a com enabled DLL.when i build the Dll then there is a tlb file also generated which reference i gave in the excel.
I am using 64 bit Operating System and 64 bit MS Office Excel.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900