Hi ?B?I0RJVi8w?=,

Not sure I understand your answer. Do you think I should start every single
Excel and Word macro with a check to find the base file path and set a value
to use within that macro ?
Seems clumsy. Is there really no way to set that as a global value ?

It depends on how everything is supposed to work. A VBA project can have
"global variables", but they can go out of scope (the assigned values are lost
because the memory has been released). Since we don't know the details of your
entire project, it's therefore difficult to give a definitive answer.

Based on experience, you'd at least want to have a function at the beginning of
each procedure, or set of linked procedures, that requires this information to
check whether a global variable contains the information (Len(theVariable) 0)
and if it doesn't (empty string), call the procedure that gets the information.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)