I need help with a coding requirement that I've not previously experienced. I have a number of folders that each contain about 100 small .csv files; for each folder I need to copy the path for each file to an open worksheet. Each folder of .csv files has its own associated workbook.
As one example, the open workbook is F:\SM\M400AD.xlsm and the active worksheet is CSV_List. The folder containing the .csv files is F:\SM\M400AD
Doing it manually, my sequence is then:
Open folder F:\SM\M400AD
Select all
Copy as path
Paste to Range("B11") of worksheet CSV_List
I need to automate this and would be grateful if a VBA guru could kindly code this for me.