Import Text File Location
 

Hi,

i'm importing text files into my worksheet. (Using the function in the
data menu so that I can auto refresh, etc).
The text files are in the same location as the worksheet

Now if I copy the worksheet to a new directory, is there a way to make
it automatically look for the text files in this new directory,
rather than having to use the file explorer?

thanks in advance



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/