references

[rjtaylor]

Hi I need some help I have an .XLA file that stores most of my code.
I set a reference to this file.
My problem is that I am now trying to create an install since I can'
control the exact path the reference is not gendered t work.

I was wondering if there is some VBA code to set that reference I ca
get the path once it is installed.

The other solution could be to install the addin since I don’t do tha
however I don’t quite know how to do that and then call the code.
Any help would be appreciated Thank

 

[Guest]

hi,
you do realise that the code file must be open to use the
macros.
I would put you code file in the xlstart folder. that way
it would open when you open excel.

 

[rjtaylor]

No I did not know that it must be open and I am not sure what you mee
by that. I did not really want to put it in the xlstart folder but
could i guess also most of the subs are private sub. Should these b
public or does it matter. thanks for your tim