I have a file that has links from two other files. Each month, I need to change the link of one of the sources to another file
Can anyone help me write a macro that will do the following:
Open up the edit links option, allow me to select a source, then open up a sharepoint location where I can select a new source file
The sharepoint link shows up as this:"https://xxxxxx.aaaa.com/sites/xxxxxfinance/Shared%20Documents/Close%20Worksheets"
I tried to create a macro that would simply setup this path as the default so when I open up edit links, it would at least start me in the right location. I can't seem to do that with the sharepoint path.
Any help would be great
thanks!
Can anyone help me write a macro that will do the following:
Open up the edit links option, allow me to select a source, then open up a sharepoint location where I can select a new source file
The sharepoint link shows up as this:"https://xxxxxx.aaaa.com/sites/xxxxxfinance/Shared%20Documents/Close%20Worksheets"
I tried to create a macro that would simply setup this path as the default so when I open up edit links, it would at least start me in the right location. I can't seem to do that with the sharepoint path.
Any help would be great
thanks!
