faustino Dina wrote:
Hi,

I have a data.xls document that uses functions defined in a library.xla.
There is also a config.xls document that initializes the library.xla. I
pretend to load the config.xls when the data.xls document is loaded, so I
put it on the XLStart folder on my PC. The library.xla is on the AddIns
folder of the Office in Program Files... It works OK in my windows 2000 PC,
but when I try to open data.xls on a windows 98 PC all the references all
wrong 'cause they all are tied to the absolute paths of my PC. Then I can't
deploy the data.xls 'cause it is machine-dependent. How can I turn the
references between documents into relative ones...., or what else can I do
to make my data.xls machine-independent?

Thanks in advance
Faustino


Application.StartupPath (returns path to XLSTART)
Application.Path (returns path to Program Files directory)

maybe just what you are looking for.

Hope this helps,

Matthew