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

--
Message posted from http://www.ExcelForum.com

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.

-----Original Message-----
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't
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 can
get the path once it is installed.

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


---
Message posted from http://www.ExcelForum.com/

.

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

--
Message posted from http://www.ExcelForum.com