Help! Import text file cannot be found

[Roy]

My Excel 2002 spreadsheet must import about 20 text files located in th
same folder as the spreadsheet file and then does a bunch o
calculations, etc., to generate a report.

When I initially set it up, it works great. BUT when I take the folde
containing the spreadsheet and the 20 text files to another computer,
get the message "Excel cannot find the text file..." and I have to red
all of the import text files again, and then it works fne again.

I need to send this excel file to numerous students and colleagues, an
it is a pain in the behind for everyone to have to fix the error.

Why can't excel find these text files inside the folder when I copy th
folder to another computer? It seems to me that an excel file should b
able to find a text file that is sitting in the same floder as it is.

I hope this is a simple fix. I've been reading help files and interne
tips, and can't find the solution. I really appreciate any help anyon
can give, either the fix or at least the reason why?

...Ro

 

[Dave Peterson]

Are you using a macro that imports the text files?

Any chance that the network share is mapped to a different letter?

If you are using a mapped drive, maybe you could replace it with the UNC (use
\\Sharename\foldername instead of x:\foldername)?

If this isn't close, you may want to post back with more details--and if you are
using a macro a little snippet of the code.