I’m hoping somebody can help me! I’ve had a long search here and can’t find anything that answers my query and I can’t believe I’m the first person ever to need to do this so hopefully it’s something you all know and I just don’t!

I have an word file that acts as an index for a large number of files (in excess of a 1000) currently these files, of various formats are stored within folders and subfolders which use the naming convention 01-Introduction though to 20-Acceptance certificate.
Some of the folders have multiple subfolders, as in within 01-Introduction there is a subfolder called 01.01- Introduction slides. Some subfolders go 5 or 6 levels deep so it could end up being 01.01.01.01.01.01 and then a single file in there.

Currently my predecessor manually made for each folder and file a (Relative) hyperlink manually which took hours /weeks and is probably why he’s not here anymore!
The links all need to be relative, not absolute as the final file is issued back to client for storage on their server. (Yes we can ensure the relative structure is maintained)



As a starter I’m trying to understand if there is a way of using VBA to look at my folder structure and then build the links for me.
The dream would be if word could then allocate a text style based on what level the subfolder was. i.e. 01-Introduction would be heading style 1 01.01 would be heading style 2.
And before everyone shouts just use excel, we can’t can’t. The client stipulates docx and pdf only.