Hard-Coding a File Location
I have Excel files in a directory on the network that I want to be updated
even if they are moved WITHIN the SAME directory but say.....in another
subfolder. Right now, they are dependent on each other so I have the
location of them hard-coded . But if I move ONE, Excel wont be able to find
it. How can I not hard-code the location but still have them be able to find
each other?
|