View Single Post
 
Old 07-17-2018, 02:03 AM
John Pryor John Pryor is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2018
Posts: 7
John Pryor is on a distinguished road
Default 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!
Reply With Quote