I have a .net provider that I want to expose in excel so that SQL queries
can be sent to the provider and data returned from the provider to populate
a excel spread sheets.

I have written an add-in and I have exposed it in EXCEL, however I do not
know how to access it using VB code?

Any suggestions.... I am very new to VB and excel macros?

Duncan.

Hi Duncan

Addins usually provide custom menu items or toolbar buttons for the host app, to trig its
own code with. Those are programmed within the addin, so I guess that's what you should
do, in C# or VB.NET or whatever you made the addin with.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.

"Duncan Winn" wrote in message
...
I have a .net provider that I want to expose in excel so that SQL queries
can be sent to the provider and data returned from the provider to populate
a excel spread sheets.

I have written an add-in and I have exposed it in EXCEL, however I do not
know how to access it using VB code?

Any suggestions.... I am very new to VB and excel macros?

Duncan.