[Solved] Make folders and files using excel vba macro and display with tree view and hyperlinks
I think that should do the trick. This macro will take folder path from cell A1 and list recursively its contents and subfolder contents with hyperlinks. Update: fixed, now it’s working. 🙂 Public Position As Integer Public Indent As Integer Sub ListFileTree() Position = 0 Indent = 0 Call RecurseFolderList(Range(“A1”).Value) End Sub Private Sub ClearFormatting(Rng … Read more