Hi,
What I need to do is quite simple.
I need to check that all clients have a specific sub-folder created for them in a specific folder (called Client Names) found in a directory.
I therefore need to download all the client sub-folders found in that folder (i.e. Client Names) to see if they match with my client list.
Every client sub-folder contains some excel files but I am NOT interested in these I only want the full list of client sub-folder names (each of which corresponds to a client name).
Folder 'Client Names' which contains client sub-folders is found in directory below:
C:\Users\user\OneDrive\Desktop\Client Names
Can you please let me know if there is an excel formula or a macro which can go into the directory look into 'Client Names' folder and return a list in an excel sheet of all sub-folders contained in it (i.e. the client names)?
Thanks,
Nic
What I need to do is quite simple.
I need to check that all clients have a specific sub-folder created for them in a specific folder (called Client Names) found in a directory.
I therefore need to download all the client sub-folders found in that folder (i.e. Client Names) to see if they match with my client list.
Every client sub-folder contains some excel files but I am NOT interested in these I only want the full list of client sub-folder names (each of which corresponds to a client name).
Folder 'Client Names' which contains client sub-folders is found in directory below:
C:\Users\user\OneDrive\Desktop\Client Names
Can you please let me know if there is an excel formula or a macro which can go into the directory look into 'Client Names' folder and return a list in an excel sheet of all sub-folders contained in it (i.e. the client names)?
Thanks,
Nic