kieranjcollins
asked on
Macro, folder and sub-folder contents
Hi,
I have seen on Experts Exchange macros to list folder files, is it possible to write a macro to list folder and sub-folder contents ?
Thanks
Kieran
I have seen on Experts Exchange macros to list folder files, is it possible to write a macro to list folder and sub-folder contents ?
Thanks
Kieran
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Matthew
The macro doesn't run and the VBA highlights "Dim FSO As Scripting.FileSystemObject ".
Compile Error:
User-defined type not defined
Kieran
The macro doesn't run and the VBA highlights "Dim FSO As Scripting.FileSystemObject
Compile Error:
User-defined type not defined
Kieran
ASKER
Matthew
I added to my VBA reference list and it worked perfect.
Thanks for the help, you deserve the points !
Thanks
Kieran
I added to my VBA reference list and it worked perfect.
Thanks for the help, you deserve the points !
Thanks
Kieran
Kieran,
Glad to help. Sorry I forgot to mention tha you needed to add the reference :)
Patrick
Glad to help. Sorry I forgot to mention tha you needed to add the reference :)
Patrick
http://search.experts-exchange.com/questions/21848083/List-all-Sub-Folders-in-a-Drive.html