Home |
Search |
Today's Posts |
#1
|
|||
|
|||
importing 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Pivot tables, external data sources and ODBC links | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |