Macro to change file path
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!
|