Reference to an add-in?

[Rusty]

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

 

[Oorang]

In the VBE go to Tools, then refrences, and select the Add-In.

 

[Rusty]

Thanks.

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

 

[Oorang]

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.