Can anyone help with a VBA syntax that loops through all folders in a certain path (EG: H:/Reports/Pick Reports),
the path has different folders called 2014,2015 etc and each folder has months. and each month has daily workbook.
my target is to pull out data from a particular worksheet in the daily workbooks.
Bookmarks