I am looking to create default file paths for Word and Excel documents along
the footer and have not come up with any solutions other than inputting the
path manually. (Shocker for time)

The aim is for anyone who views them can find them easliy in our shared
drive.

I have seen this done before but I am unsure about how to make sure the
default is constantly updated according to the path it is saved on.