Internal URLs

Hi,

I have a cell, that contains a reference to a document - i.e
C:\documents\test.doc - is there anyway that I can automatically convert
either by way of text recognition (ie the program recognises that is an
internal URL) or by way of cell reference (ie that whatever is in that cell
is an internal URL), so that when I type C:\ etc - it automatically creates
an internal hyperlink.

My email address is - myname at cdtoday.co.uk
--

thanks

Antony
(This email has been checked
by Norton Antivirus 2004)

Antony wrote:
I have a cell, that contains a reference to a document - i.e
C:\documents\test.doc - is there anyway that I can automatically convert
either by way of text recognition (ie the program recognises that is an
internal URL) or by way of cell reference (ie that whatever is in that cell
is an internal URL), so that when I type C:\ etc - it automatically creates
an internal hyperlink.


If you type file:\\C:\Temp\Book1.xls then a hyperlink will automatically be
created.




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

Cheers - just what I was looking for )

"Bill Manville" wrote in message
...
Antony wrote:
I have a cell, that contains a reference to a document - i.e
C:\documents\test.doc - is there anyway that I can automatically convert
either by way of text recognition (ie the program recognises that is an
internal URL) or by way of cell reference (ie that whatever is in that
cell
is an internal URL), so that when I type C:\ etc - it automatically
creates
an internal hyperlink.


If you type file:\\C:\Temp\Book1.xls then a hyperlink will automatically
be
created.




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