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…...for which you want to set a hyperlink base. On the File menu, click...ensuring that relative paths in hyperlinks are correctly interpreted...