Hi,
I am new to VBA and hope someone can help me? The macro should runs through to the third level subfolder from a main folder and extract the excel files from all the folders EXCEPT folders with a specific name.
So for example Main location: H:\Mijn documenten\Test add folders--Subfolder 1---subfolder 1.1 (don't copy files from folders "correspondence" and "old"----excel file (xls*).
I would like to paste this in a new folder.
Would really appreciate the help. Thanks in advance!