Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
I'm creating hyperlinks with the format: "file://" & sFile
Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
It seem one workstation is changing the hyperlinks from absolute to relative
as the hyperlink is programmatically created. Is there a setting or something I can do to stop this behavior? "MAB" wrote: I'm creating hyperlinks with the format: "file://" & sFile Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
It seems one workstation is automatically applying a relative address even
though I'm programmatically supplying and absolute address. Any thoughts on how I can stop this behavior? "MAB" wrote: I'm creating hyperlinks with the format: "file://" & sFile Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them
with by using the =hyperlink() worksheet function. ====== I'm not sure if this will work with your hyperlinks, but a few people have said that this has resolved the problem for them: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) MAB wrote: It seems one workstation is automatically applying a relative address even though I'm programmatically supplying and absolute address. Any thoughts on how I can stop this behavior? "MAB" wrote: I'm creating hyperlinks with the format: "file://" & sFile Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
Thanks for the response Dave.
The hyperlinks are pointing to diferent servers and various folder structures. So, would Hyperlink Base help here? "Dave Peterson" wrote: Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them with by using the =hyperlink() worksheet function. ====== I'm not sure if this will work with your hyperlinks, but a few people have said that this has resolved the problem for them: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) MAB wrote: It seems one workstation is automatically applying a relative address even though I'm programmatically supplying and absolute address. Any thoughts on how I can stop this behavior? "MAB" wrote: I'm creating hyperlinks with the format: "file://" & sFile Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Absolute vs. relative hyperlinks
I don't know. You'll have to try it. Please post back with your results.
MAB wrote: Thanks for the response Dave. The hyperlinks are pointing to diferent servers and various folder structures. So, would Hyperlink Base help here? "Dave Peterson" wrote: Maybe you could drop the Insert|Hyperlink style of hyperlinks and replace them with by using the =hyperlink() worksheet function. ====== I'm not sure if this will work with your hyperlinks, but a few people have said that this has resolved the problem for them: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) MAB wrote: It seems one workstation is automatically applying a relative address even though I'm programmatically supplying and absolute address. Any thoughts on how I can stop this behavior? "MAB" wrote: I'm creating hyperlinks with the format: "file://" & sFile Where sFile is a string variable holder the UNC path and file name. It seems sometime at some point after the hyperlinks are created, they're changing from absolute to relative. Most spread sheet I populate with hyperlinks stay absolute but some change to relative (why?). Is there anything I can do to assure they stay absolute? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change hyperlinks from relative to absolute | Excel Discussion (Misc queries) | |||
Relative and absolute hyperlinks | New Users to Excel | |||
Mix of relative and absolute? | Excel Programming | |||
Globally change relative-addressed hyperlinks to absolute-addr | Excel Worksheet Functions | |||
Chg Absolute to Relative | Excel Programming |