Re: File and Folder Index with Hyperlinks
Cheers Mate, you are a legend. This is exactly what I want. 
Posts by SMW87
-
-
What I am trying to do is to create an Index of all the files and folders I have in a project folder.
[tr]
I want this to be structured in a way that resembles the actual folder structure. Something like this.
[TABLE="class: grid, width: 500"]
[td]Master Floder
[/td]
[td]Sub Folder 1
[/td]
[td]Sub Sub Folder 1
[/td]
[td]File 1
[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td][/td]
[td]File 2
[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td][/td]
[td]File 3
[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td]Sub Sub Folder 2
[/td]
[td]File 1
[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td][/td]
[td]File 2
[/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td]File 1
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td]File 2
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td]Sub Folder 2
[/td]
[td]File 1
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td][/td]
[td]File 2
[/td]
[td][/td]
[/tr]
[tr]
[td][/td]
[td]Sub Folder 3
[/td]
[td][/td]
[td][/td]
[/tr]
[/TABLE]
I have seen a few bits of code that will list the all the files or all the folders. But I have yet to find code that can list all files and all folders and sub folders.
I also want to be able to hyperlink all of them.
I Might be asking for a bit much but maybe one of you VBA gurus might be able to give me a hand.
Cheers
Stephen -
Re: List folders, subfolders and files using macro
AJJ, What you are looking for is exactaly what I am looking for. I would also love it if it was hyperlinked aswell.
I have had a look at the earlier post roy listed but it dose not list files, only folders. -
Re: Edit code to create hyperlinks to files in folders, subfolders, and shortcuts
did you ever get this code done. I would be very interested in this code.