load CSV files as worksheets from a list in cells

Hi all,

I have a Macro from another source that searches through a directory tree for particular files, and enters the filenames of the files and directories in cells in a worksheet which I'm using as an Index.

Using that list, I want to load the CSV files as worksheets in the workbook, iteratively going through the rows, and using alphanumerical text from cells in the same row as worksheet names.

The sort of worksheet I'm working from is attached.

Col
A directory
B filename
C dataset name
D analysis type

I'd like the name of the worksheet to be

Please Login or Register  to view this content.

The full path and file location is

Please Login or Register  to view this content.

because the path values in Column A have no trailing "\".

The number of rows is always variable, so it needs to be some sort of For Each loop I think.. but I'm not sure where to start because I'm not sure how to reference the different cells for sheet names as rows are traversed.

any help would be wonderful.

Thanks kindly for helping Chippy.

This is a good start, but it throws an error: "Copy method of Worksheet class failed"
and the macro is also opening the worksheets to new workbook(s) [hard to tell, because it dies on the first one]. I'd like the csv spreadsheets to be imported into the open workbook as additional sheets.

List is in range is A1:A and the sheet name should be drawn from Columns C&D.

Modified here, but still has the above issue.

Please Login or Register  to view this content.

OK it's working, thanks for your help Chippy.

With a little help from this post in this forum, I got it working.

Please Login or Register  to view this content.

This now does it into the same workbook.

cheers.. solved.