Home |
Search |
Today's Posts |
#1
|
|||
|
|||
import external data from changing file name
I would like to set up an external data link to import data from a text file
into excel. The problem is that I need the link to look for a new file name each day. So, each day I need to import the data from the new file to the same location in Excel. The names of the text files will always follow a particular standard based on the current date (i.e. DATABASECCYYMMDD.TXT). How can I have the link always import data from the text file with the current date in its name? Thank you, Nathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Error: Data May Have Been Lost | Excel Discussion (Misc queries) | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) | |||
Excel 97/2000 - Help with looking up external data. | Excel Worksheet Functions | |||
Import External Data | Excel Worksheet Functions |