Hi, I receive 65 CSV files everyday. The name of each file is alaways only the date changes.
Currently I have this macro
which I can use to open 1 specific file by choosing the date. (I only need to change the date in cell C4).Please Login or Register to view this content.
Is it possible that by choosing 1 date I can open all of the files into 1 spreadsheet on separate tabs.
So I will have all of the files for a given date opened in one spreadsheet and into 65 separate tabs. Any help would be much apreciated. Cheers.
Bookmarks