Hi
if you put your filename in cell D1 use the following formula in cell
A1:
=HYPERLINK(D1 & "may_folder!$a$1")
if you really want a hyperlink (and not just a transfer of the cell
value.

--
Regards
Frank Kabel
Frankfurt, Germany


gr8guy wrote:
Hi,

Is it possible to create a macro which will change the name of the
workbook file("eijaz.xls"), in a hyperlink formula, to some other
workbook names i feed to the macro (through some input box), for a
given range(which i can specify through again, input box)?

e.g:
the link would be something like this:
A
B C
='["eijaz.xls"]may_folder!$a$1 ='["eijaz.xls"]may_folder!$b$1
='["eijaz.xls"]may_folder!$c$1
='["eijaz.xls"]may_folder!$a$2 ='["eijaz.xls"]may_folder!$b$2
='["eijaz.xls"]may_folder!$c$2
='["eijaz.xls"]may_folder!$a$3 ='["eijaz.xls"]may_folder!$b$3
='["eijaz.xls"]may_folder!$c$3
='["eijaz.xls"]may_folder!$a$4 ='["eijaz.xls"]may_folder!$b$4
='["eijaz.xls"]may_folder!$c$4
='["eijaz.xls"]may_folder!$a$5 ='["eijaz.xls"]may_folder!$b$5
='["eijaz.xls"]may_folder!$c$5

here, i want to change only the name of the file to some other name
say, "zaki.xls", so the same name will get entered in the hyperlink
for the whole range.

how can it be done?

Rgds,

Eijaz