MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlink Base value

Posted by Tom on January 17, 2002 8:44 AM

In VBA, how can I access the value of the Hyperlink Base found on the Summary tab under File, Properties in Excel. I don't need to programatically set it, but merely get the current value. Thanks in advance.


Posted by Juan Pablo G. on January 17, 2002 9:15 AM

Maybe this ?

MsgBox ActiveWorkbook.BuiltinDocumentProperties(29).Value

Juan Pablo G.