Using add-in in VBA with another module?
 

Yes.

There is only one module within the addin. I created anothe
spreadsheet and tried to access the addin's module from the ne
spreadsheet's module.



Juan Pablo González Wrote:
Is the other module outside of the Addin ?

--
Regards

Juan Pablo Gonzále

--
thinkingfiel
-----------------------------------------------------------------------
thinkingfield's Profile: http://www.excelforum.com/member.php...fo&userid=1618
View this thread: http://www.excelforum.com/showthread.php?threadid=27680

Using add-in in VBA with another module?
 

make sure the addins "project name" is unique (not VBAproject)
then add a reference to it in your "calling" project.

then activate the "calling" workbook
then open object browser, select the references "addin project"
in the ObjBrowsers dropdown to ensure the functions
are really exposed by the addin. (and not blocked by a line called..
Option Private module?



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

thinkingfield wrote in message
:


Yes.

There is only one module within the addin. I created another
spreadsheet and tried to access the addin's module from the new
spreadsheet's module.



Juan Pablo González Wrote:
Is the other module outside of the Addin ?

--
Regards

Juan Pablo González