Reference to an add-in?

Rusty

Board Regular
Joined
Apr 8, 2002
Messages
108
Hi,

Just curious as to if anyone knows how to reference to an add-in?

I use an add-in, and when you utilise it as part of a macro, then go look in VBA Project Explorer, there is underneath your modules a folder called references and a little arrouw/symbol with: "Reference to xxx.xla"

Thanks
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
In the VBE go to Tools, then refrences, and select the Add-In.
 

Rusty

Board Regular
Joined
Apr 8, 2002
Messages
108
Thanks. :biggrin:

I've got it figure how to add it in if it dosn't exist.
 

Oorang

Well-known Member
Joined
Mar 4, 2005
Messages
2,071
:LOL: put it on a shared drive or a website then make it download it if it's not there. Alternatly you can put teh functions from the add in into the workbook itself.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,731
Messages
5,573,889
Members
412,555
Latest member
mark84
Top