Dynamic folder path using vba

[militambe3171]

Hi

Every week i create excel report and for that i take data from different folders. Folder path and file name is not fixed it changes every week so i want to create one macro that will take dynamic folder path and file name

 

[wellsr]

What's your logic (your system) for selecting the folder path and file name each week?