I'm trying to create a macro which will simply take a changed hyperlink
address (i.e. "C:\Documents and Settings\XXXX\yyy.doc") and populate an
existing hyperlink in excel. The hyperlink is in one column and the hyperlink
address is in the adjacent column. I tryed to make a macro which would copy
the address contents (CTRL+C) and then select the adjacent hyperlink, select
"edit hyperlink" and then paste (CTRL+V) into the edit hyperlink window.
I have 2 columns of about 50 or so hyperlinks and corresponding addresses.
The links currently reflect the corresponding addresses and I wanted to
cretae a macro so that if the drive or folder cahnges I could do it more
automatically to each hyperlink.
When I record a macro now it just uses the specific example on each link, I
want it to copy the address for the cell it is in and paste it into the
hyperlink address window independently. I tried using the "Relative cell"
button but that does not seem to make a difference.
The other solution that I wanted to try is to use the "find/replace"
function on the hyperlinks but I guess it wont look at the hyperlink address,
only the displayed hyperlink text. (this woul dbe the easiest method if
someone knew how to have the "find/replace" function work on hyperlinks.
Thanks,
Jim