Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call COM Add-In functions from a macro
I am new to COM Add-Ins and have implemented the
Microsoft example: HOW TO: Build an Office COM Add-in by Using Visual Basic .NET Reg: http://support.microsoft.com/default.aspx? kbid=302896 This worked fine. However, it only shows how to include a user defined button. I wish to add additional member functions to the connect class, or a new class, that can be called from macros within Excel. I am using vb.Net 2002 and Excel XP. Any help much appreciated. Regards: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call COM Add-In functions from a macro
Graham,
Here is an article that shows how. It is not .Net based, but you should still be able to apply HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions http://support.microsoft.com/default.aspx?kbid=285337 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Graham" wrote in message ... I am new to COM Add-Ins and have implemented the Microsoft example: HOW TO: Build an Office COM Add-in by Using Visual Basic .NET Reg: http://support.microsoft.com/default.aspx? kbid=302896 This worked fine. However, it only shows how to include a user defined button. I wish to add additional member functions to the connect class, or a new class, that can be called from macros within Excel. I am using vb.Net 2002 and Excel XP. Any help much appreciated. Regards: |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call COM Add-In functions from a macro
Bob,
Thanks for the reference. I have tried to adapt the VB6 Automation ideas but have got in a bit of a muddle. In my original attempt based on: HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions http://support.microsoft.com/default.aspx?kbid=285337 the COM Add-In loads and the OnConnection routines operate and bring up messages when the Add-In loads. The problem is that I cannot access any functions that I include from Excel macros. I just cannot seem to access the Add-In direct. Also, I cannot see the Add-In under tools/Addins even though I know it has loaded. Sorry if I am being stupid :-) Regards, Graham |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to call COM Add-In functions from a macro
Graham,
What version of Excel do you have? I ask because I have just read the article, and it specifically mentions XL2002. I re-created the example using XL2002, and when I clicked the Automation tab, that created the ProgId registry key mentioned in the other article. And everything worked fine (except the functions seemed odd<g). Then I tried to repeat it in XL2000, and I got the same results as you. I manually created the I knew the addin loaded (I added a MsgBox to prove it), but I couldn't see it either, or run those functions. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Graham" wrote in message ... Bob, Thanks for the reference. I have tried to adapt the VB6 Automation ideas but have got in a bit of a muddle. In my original attempt based on: HOWTO: Create a Visual Basic Automation Add-in for Excel Worksheet Functions http://support.microsoft.com/default.aspx?kbid=285337 the COM Add-In loads and the OnConnection routines operate and bring up messages when the Add-In loads. The problem is that I cannot access any functions that I include from Excel macros. I just cannot seem to access the Add-In direct. Also, I cannot see the Add-In under tools/Addins even though I know it has loaded. Sorry if I am being stupid :-) Regards, Graham |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can run a macro ( call a macro) on selection of any filtercriteria? | Excel Worksheet Functions | |||
Call an Access macro from an Excel macro | Excel Discussion (Misc queries) | |||
What do you call values used with a functions? | Excel Worksheet Functions | |||
Can you call functions between sheets in the same book in excel? | Excel Worksheet Functions | |||
How to call worksheet functions from Access ? | Excel Worksheet Functions |