Auto-import Text Files Using Single Cell Value.

Hello,
I wonder if this can be done. I have a list of the csv files containing price data:

EURUSD10080.CSV
EURUSD1440.CSV
EURUSD240.CSV
EURUSD60.CSV
USDJPY10080.CSV
USDJPY1440.CSV
USDJPY240.CSV
USDJPY60.CSV
GBPUSD10080.CSV
GBPUSD1440.CSV
GBPUSD240.CSV
GBPUSD60.CSV
USDCHF10080.CSV
USDCHF1440.CSV
USDCHF240.CSV
USDCHF60.CSV
AUDUSD10080.CSV
AUDUSD1440.CSV
AUDUSD240.CSV
AUDUSD60.CSV
USDCAD10080.CSV
USDCAD1440.CSV
USDCAD240.CSV
USDCAD60.CSV
NZDUSD10080.CSV


I wonder if it can be possible to have excel structure the data query in such a way that each time I change the name of a single cell (e.g. Set it to EURUSD10080.CSV ) – it will load the corresponding EURUSD10080.CSV file into the worksheet?

I have attached a few CSV files.

Will be glad to hear what you think!

D

I recorded one import sequence in a macro:

Please Login or Register  to view this content.

I wonder how do I made this macro import the data using the file name that is specified in a cell???