I'm essentially in the same boat as the person in this thread: Linking excel data to Word document so links survive file namechange | Microsoft Office Forums

I've got macropod's autofldupdt macro imported and it's working great (many thanks!). Starting from post #9, it looks like the modifications results in the requirement of having both the word and excel files having the same name, e.g. job4.docx and job4.xlsx.



In my situation, the files all have a standard prefix of Final Report_job4.docx and Tables_job4.xlsx. How do I modify the code to reflect this?