Getting all sub folders and files within a folder

Hello all, I have the following problem:

I run my sub which opens up a folder browser, however this only gets the folder, when I would like it to get files and sub folders within the folder.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

BUMP

I got told to use 'vbNormal' instead of 'vbDirectory' in my code, however nothing changes. Any ideas?

Maybe you can adapt this. Change the path below in red. Also make sure you have sheet1 in workbook. Will list all folders/files/subfolders/files.

Please Login or Register  to view this content.