#1
|
|||
|
|||
Hyperlinks defaulting to absolute instead of relative!!!
I have the following VBA code to update a single link that is using a relative address but when the document is saved the address becomes absolute.
I have debugged the code and confirmed that "address" is a relative path. Sub UpdateLink(address as string) ChangeFileOpenDirectory ActiveDocument.Path ActiveDocument.Hyperlinks.Add Anchor:=Selection.Range, address:=address, SubAddress:="", ScreenTip:="", TextToDisplay:="Link" End Sub I have checked Options->Advanced->Web Options->Update Links on Save = Ticked. Also once I have created one link programatically in the document any links manually created by the user also become absolute! Any ideas what I'm doing wrong? Walter |
#2
|
|||
|
|||
The fix was to set:
Options->Advanced->Web Options->Update Links on Save = Un-Ticked. This seems to have the opposite affect as to when only user created hyperlinks are made!!! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel absolute reference | dschlachter | Excel | 6 | 06-16-2015 03:02 PM |
Currency number entered defaulting to pence value not pounds | David Brown | Excel | 1 | 05-13-2015 06:27 AM |
Always on top, absolute times for slideshow | cab07 | PowerPoint | 0 | 07-06-2014 05:06 AM |
Keeping an absolute reference in a cell | bremen22 | Excel | 7 | 01-16-2014 11:06 AM |
Outlook search defaulting to "All Mail Items"??? | Ninafel | Outlook | 0 | 12-02-2010 02:01 PM |