Reading in multiple csv files from a list of filenames

Howdy all,

My goal is to insert data from a csv file into a new worksheet. While I've got a macro that can manage that part, it will only load one file at the time. Other snippets of code I've run across will load everything in the directory, but I want to restrict it to a list of filenames that I specify in a worksheet (i.e. Sheet 1, A1:A?).

Any help you could offer would be greatly appreciated.

Thanks,
Joe

Please Login or Register  to view this content.

TexAggie

Welcome to Exceltip forum

Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)

Macro modified to loop through cells in column A
Assumes entry in each cell is file name only
Assumes no blank cells between A1 and last used cell in column A
Assumes only file names listed in column A

Please Login or Register  to view this content.