Excel COM Add-in

[Christoph Malherbe]

Hi,

I have a COM add-in which has methods to
a. invoke a form where a user may capture some data
b. return a single value.

I also have a VBA wrapper written to be able to hook this add-in in Excel.

I would like
a. to access the cells on the active worksheet from my add-in's
form(cell ranges are specified in the add-in form)
b. when the user types the function, that the function's parameters are
displayed(intellisense)

Your help will be appreciated

 

[Fredrik Wahlgren]

Hi,

I have a COM add-in which has methods to
a. invoke a form where a user may capture some data
b. return a single value.

I also have a VBA wrapper written to be able to hook this add-in in Excel.

I would like
a. to access the cells on the active worksheet from my add-in's
form(cell ranges are specified in the add-in form)
b. when the user types the function, that the function's parameters are
displayed(intellisense)

Your help will be appreciated

Is your COM add-in also an automation add-in?

/Fredrik