Hi, I am trying to keep a hyperlinked function up to date when I change the filename of a workbook(such as through SaveAs.) For instance, if I change the filename to Book2.xlsm, the hyperlink formula (below) will be rendered useless.
<TABLE cellSpacing=0 cellPadding=6 width="100%"...