View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MAB MAB is offline
external usenet poster
 
Posts: 40
Default 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?