AddIn - Calling functions from VBA

I've written an Addin, added it to the list of available addins and installed
it. I can use the functions within the AddIn within Excel worksheets. What
I would also like to be able to do is call the function from VBA. How can I
do this?

Thanks,

Graham

Graham,

Set a reference to your Add-in through the VBE, Tools, References....

HTH,
Bernie
MS Excel MVP


"GrahamB" <GrahamB@discussions.microsoft.com> wrote in message
news:148EDE4E-708B-4138-8944-A19591047B0D@microsoft.com...
> I've written an Addin, added it to the list of available addins and installed
> it. I can use the functions within the AddIn within Excel worksheets. What
> I would also like to be able to do is call the function from VBA. How can I
> do this?
>
> Thanks,
>
> Graham

Bernie,

Thanks for your note. I unfortunately get a error message "Name conflicts
with existing module, project or Object library". Any ideas what I have to
rename in my addin to prevent me referencing it?

Thanks Graham

"Bernie Deitrick" wrote:

> Graham,
>
> Set a reference to your Add-in through the VBE, Tools, References....
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "GrahamB" <GrahamB@discussions.microsoft.com> wrote in message
> news:148EDE4E-708B-4138-8944-A19591047B0D@microsoft.com...
> > I've written an Addin, added it to the list of available addins and installed
> > it. I can use the functions within the AddIn within Excel worksheets. What
> > I would also like to be able to do is call the function from VBA. How can I
> > do this?
> >
> > Thanks,
> >
> > Graham
>
>
>

Graham,

Excel does references by "Project name", which doesn't change even if the workbook name is changed.
The default is VBAProject, so you probably have a whole bunch of VBAProject's. To change the name
of your add-in, press F4 to open the properties window, select the add-in in the Explorer window,
and change VBAProject to something unique, like "MyVBAAddIn"

HTH,
Bernie
MS Excel MVP


"GrahamB" <GrahamB@discussions.microsoft.com> wrote in message
news:1852AF52-5330-4354-9A0F-31FBBB1544A1@microsoft.com...
> Bernie,
>
> Thanks for your note. I unfortunately get a error message "Name conflicts
> with existing module, project or Object library". Any ideas what I have to
> rename in my addin to prevent me referencing it?
>
> Thanks Graham
>
> "Bernie Deitrick" wrote:
>
>> Graham,
>>
>> Set a reference to your Add-in through the VBE, Tools, References....
>>
>> HTH,
>> Bernie
>> MS Excel MVP
>>
>>
>> "GrahamB" <GrahamB@discussions.microsoft.com> wrote in message
>> news:148EDE4E-708B-4138-8944-A19591047B0D@microsoft.com...
>> > I've written an Addin, added it to the list of available addins and installed
>> > it. I can use the functions within the AddIn within Excel worksheets. What
>> > I would also like to be able to do is call the function from VBA. How can I
>> > do this?
>> >
>> > Thanks,
>> >
>> > Graham
>>
>>
>>