Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-17-2015, 08:07 PM
wdzambotti wdzambotti is offline Hyperlinks defaulting to absolute instead of relative!!! Windows XP Hyperlinks defaulting to absolute instead of relative!!! Office 2007
Novice
Hyperlinks defaulting to absolute instead of relative!!!
 
Join Date: Sep 2013
Posts: 4
wdzambotti is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 08-17-2015, 09:03 PM
wdzambotti wdzambotti is offline Hyperlinks defaulting to absolute instead of relative!!! Windows XP Hyperlinks defaulting to absolute instead of relative!!! Office 2007
Novice
Hyperlinks defaulting to absolute instead of relative!!!
 
Join Date: Sep 2013
Posts: 4
wdzambotti is on a distinguished road
Default

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!!!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks defaulting to absolute instead of relative!!! excel absolute reference dschlachter Excel 6 06-16-2015 03:02 PM
Hyperlinks defaulting to absolute instead of relative!!! 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
Hyperlinks defaulting to absolute instead of relative!!! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft