Okay,
I have a two worksheet .htm spreadsheet.
The first sheet hyperlinks by =hyperlink to the second sheet where the
location is determined by the =cell("filename") function and a
concatenated filename.
When I copy the .htm to another location, the =cell("filename") updates
to the new location, but strangely the =hyperlink remains as the old
path.
How do I ensure that it is updated when the htm file is copied to a new
location?
--
ColB
------------------------------------------------------------------------
ColB's Profile:
http://www.excelforum.com/member.php...o&userid=36350
View this thread:
http://www.excelforum.com/showthread...hreadid=571353