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