Hi Again.


I have a question about creating some means of finding the filepath of existing links to one excel document and replacing with the filepath of a new source document. My document has over 200 links so using the standard links management tool would take forever.

Essentially, I would like to create some sort of useform that would allow me to browse files on my computer and select the appropriate excel workbook to redirect the links to.

I appreciate this may be a huge ask, but even a step in the right direction would be helpful.

I am a novice at VBA in word and a beginner on VBA in excel, so my knowledge is basic.

Thank you!