Hyperlink.

A folder contains 1100 excel workbooks of clients named based on their
account numbers.
A main file contains this

54625 hyperlink to D:\accounts\54625.xls
74351 hyperlink to D:\accounts\74351.xls
and so on...

I need a cell where i can simply enter 54325, and i should get a hyperlink
to D:\accounts\54325.xls in the next cell.
I tried using D:\accounts\ & 54325 & .xls and all, but that does not work..

Any other way to do this?
Thanks.

trythis
in B1 type
="D:\accounts\"&A1&".xls"
(note apostrophes)
mow if you ener in A1
54625
B1 will be corresponding vlaue
now insert(menubar)-hyperling
in the <insert-hyperlink> window choose
Place in this document
choose the correct sheet
and enter B1
<type cell reference>

click ok

B1 will become hyperlink(blue color)
as you change A1 the hyperlink changes

is this what youwant.
if so modify as you require


Nimit Mehta <chocofilium@hotmail.com> wrote in message
news:B213DD8C-D402-4F83-B32A-16E040B03FA2@microsoft.com...
> A folder contains 1100 excel workbooks of clients named based on their
> account numbers.
> A main file contains this
>
> 54625 hyperlink to D:\accounts\54625.xls
> 74351 hyperlink to D:\accounts\74351.xls
> and so on...
>
> I need a cell where i can simply enter 54325, and i should get a hyperlink
> to D:\accounts\54325.xls in the next cell.
> I tried using D:\accounts\ & 54325 & .xls and all, but that does not
work..
>
> Any other way to do this?
> Thanks.

So i will have to use as a helper coloumn. And in C1 i can use =hyperlink(B1).
Working fine..
Thanks..

"R.VENKATARAMAN" wrote:

> trythis
> in B1 type
> ="D:\accounts\"&A1&".xls"
> (note apostrophes)
> mow if you ener in A1
> 54625
> B1 will be corresponding vlaue
> now insert(menubar)-hyperling
> in the <insert-hyperlink> window choose
> Place in this document
> choose the correct sheet
> and enter B1
> <type cell reference>
>
> click ok
>
> B1 will become hyperlink(blue color)
> as you change A1 the hyperlink changes
>
> is this what youwant.
> if so modify as you require
>
>
> Nimit Mehta <chocofilium@hotmail.com> wrote in message
> news:B213DD8C-D402-4F83-B32A-16E040B03FA2@microsoft.com...
> > A folder contains 1100 excel workbooks of clients named based on their
> > account numbers.
> > A main file contains this
> >
> > 54625 hyperlink to D:\accounts\54625.xls
> > 74351 hyperlink to D:\accounts\74351.xls
> > and so on...
> >
> > I need a cell where i can simply enter 54325, and i should get a hyperlink
> > to D:\accounts\54325.xls in the next cell.
> > I tried using D:\accounts\ & 54325 & .xls and all, but that does not
> work..
> >
> > Any other way to do this?
> > Thanks.
>
>
>