Help with importing csv files which partial filenames are cell values

[WashCaps]

The GetData Macro listed below prompts the user to browse and select a csv file then imports the data of the selected csv file into a predetermined cell of the active worksheet. Then process repeats 3 more times to import data into the next predetermined cell in the same active worksheet.

In cell A7 I have text "_300", cell G7 "_312", cell M7 "_400" and cell S7 "_420" (without the quotes). The text in these cells are partial filenames. I would like the Macro to only prompt the user to select a folder and then automatically use the text in the cells A7, G7, M7 & S7 to find the corresponding full filename within the user selected folder and import the data in to those cells. An example of the full filenames in a folder are: File_00_300.csv, File_00_312.csv, File_00_400.csv, File_00_420.csv. The File_## portion of the filename can change from folder to folder. How do I go about using the text in a cell to search a user specified folder for the full filename and use the corresponding text in that cell as the data import destination? Is this even possible? hope this makes sense.

Thanks in advance for your help!

Please Login or Register  to view this content.

- WashCaps