How to copy from different files and maps based on the week number in VBA

[Bassie]

Hey everyone,

I would like to make a macro that searches every folder within a folder that has a folder with the current weeknumber in it (let me explain).

- I currently have a folder with the names of each of my colleagues as seperate folders and 1 folder that is titled "archive".

- Every colleagues folder has folders in it with the week numbers. For example my folder had 3 folders called: "week 6" "week 7" "week 8", but more will be added down the line

- I want to extract information from all excel files that are in the current week number for every colleague (week 7 in the example). The folder "archive" should be excluded and new colleague will be added down the line.
I want to do this for every colleague at the same time

Is there an easy way to do this?

Thanks a lot in advance and if my explanation wasnt clear I can always answer questions.
Bassie

 

[Marc L]

Hey,​

​

just use a string variable to store the name of the expected week​

then use the Dir VBA function to store the folders of the root folder in a string array variable​

then use a For Each loop on this string array variable to list each week folder content by combinating the array content & the string week variable …​

​

 

[22gree]

Hey,​

​

just use a string variable to store the name of the expected week​

then use the Dir VBA function to store the folders of the root folder in a string array variable​

then use a For Each loop on this string array variable to list each week folder content by combinating the array content & the string week variable …​

​

I am having a similar issue, does this advise apply to the post I just made? thanks

Selecting all files from folder by week number

Hello I am trying to edit this piece of code that compiles all workbooks in a folder to only compile workbooks in a certain week, I'm stuck and am unsure how to proceed. I have looked around and seem to be unable to find someone else with this exact problem, if I could get some help or a link to...

www.mrexcel.com