Using variables to import csv files

[ekcut]

I have used this macro to open CSV files based on the content of a cell. (Cell C24 in workbook "ELO")
These files are just a number. (eg 20001.csv)
I have files 20001.csv to 21230.csv in directory C:\NHL\GetPbP\TOI2013\

I run a macro to increase the value of c24 each time it is run
20001, then 20002 etc which will then import that file.
This all works fine and dandy!

Please Login or Register  to view this content.

Now I need to import csv files that are a mix of number and text.
(eg "20001 shifts.csv")

Now the "shifts" text is fixed...all files have this text, the only variable is the number which is located in cell "N2"

Can you help me import the files I need?

I run a macro that will change the value in cell "N2" and I wish to import the CSV file based on that file name. 20001 shifts.csv, then 20002 shifts.csv etc

Thanks

[karedog]

Hi,

Change your first 2 lines code above with this :

Please Login or Register  to view this content.