Hi All,
Have watched multiple videos and looked through examples but can't seem to find what I am after...
I would like to look through a folder and if the file contains todays date anywhere in the name of the file then copy to sheet 1 of the current workbook (not in the same directory). These source workbooks only ever contain one worksheet but the name changes constantly.
If there are multiple files containing todays date I would like them to append to the same worksheet 1.
Sample folder where source files are G:\Home\Performance
Directory of workbook where the paste/append takes place C:\Users\me
Sample file name example HPhde_20220321_da.csv (date will always start and end with an underscore and will always be .csv).
Hopefully that is clear...
Any help would be much appreciated.
Have watched multiple videos and looked through examples but can't seem to find what I am after...
I would like to look through a folder and if the file contains todays date anywhere in the name of the file then copy to sheet 1 of the current workbook (not in the same directory). These source workbooks only ever contain one worksheet but the name changes constantly.
If there are multiple files containing todays date I would like them to append to the same worksheet 1.
Sample folder where source files are G:\Home\Performance
Directory of workbook where the paste/append takes place C:\Users\me
Sample file name example HPhde_20220321_da.csv (date will always start and end with an underscore and will always be .csv).
Hopefully that is clear...
Any help would be much appreciated.