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
The full path and file location is
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.
Bookmarks