Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Com object for excel using vb.net
How can i create a com object so that i can embed into excel worksheet
-- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Com object for excel using vb.net
1) Go to VS.net and create a new classlibrary project under visua
basic. 2) delete the classfile that it generates and add a new item: a co class item and give it whatever name you feel appropriate 3) VS.net will automaticcally create the headers/contsructors and th guids...not to mention it will auto turn on the register as co component in your project props 4) build your solution and then in excel go to the vba editor and add reference to either the .dll or the .tlb file 5) create an instance of your com dll class such as dim myClassInstance as new myDll.myClass 6) to call a function in your dll all you need to do is myClassInstance.myDllFunction() 7)Tada :- -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Excel Object From C# | Excel Discussion (Misc queries) | |||
Creating Worksheet using Server Object | Excel Worksheet Functions | |||
Creating a picture/object | Excel Discussion (Misc queries) | |||
Creating Worksheet using Server Object | Excel Worksheet Functions | |||
Creating a Range object in .Net | Excel Programming |