View Single Post
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

Fred wrote:
How can we FORCE Excel to use the drive name and NOT the UNC?


How about
=HYPERLINK("S:\Worddoc.doc","Word doc")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup