I have a directory with 100 Excel files in it (let's call it c:\data).
I want to write a macro (in a separate file) which creates a list of all the files in the directory c:\data in column A.
Thus if the files in C:\data were RHH100.xls RHH203.xls and RHH675.xls, my macro (in file C:\control\master.xls) would run and then Column A in Sheet 1 would have the three file names in it.
Can anyone help with this at all ?
Thanks
Dan
I want to write a macro (in a separate file) which creates a list of all the files in the directory c:\data in column A.
Thus if the files in C:\data were RHH100.xls RHH203.xls and RHH675.xls, my macro (in file C:\control\master.xls) would run and then Column A in Sheet 1 would have the three file names in it.
Can anyone help with this at all ?
Thanks
Dan