Hello,
I need a function to change the HyperlinkBase like this:
workbook.Settings.HyperlinkBase = “.”;
Instead of changing it manuylly:
Open the Excel document for which you want to set a hyperlink base.
On the File…...changing it manuylly: Open the Excel document for which you want...Linkbase box, type . Reason: If Excel links with a relative path exist...