I don't want to recreate the wheel here but also I can't find what I am looking for anywhere. It seems like this may be fairly common, if not I will go ahead and make one myself, but if someone has something like this it'd be MUCH appreciated!
I am looking for a macro that will go into a folder, and show the file/folder structure in a tree view like internet explorer. As well as displaying the sizes of the files on an excel worksheet.
I know there's an addin that does this perfectly, but I have to use a macro for this.
So if anyone has one please can you share it? If not, like I said I am confident I am capable of making one, but don't want to re-invent the wheel if someone has done it already.
Thanks!
I am looking for a macro that will go into a folder, and show the file/folder structure in a tree view like internet explorer. As well as displaying the sizes of the files on an excel worksheet.
I know there's an addin that does this perfectly, but I have to use a macro for this.
So if anyone has one please can you share it? If not, like I said I am confident I am capable of making one, but don't want to re-invent the wheel if someone has done it already.
Thanks!
