I've just finished rewriting an addin called Synkronizer which
uses this technique for its reports.

Please download Synkronizer from www.synkronizer.com ,
run a report on multiple worksheets.. then have a look at the way the
hyperlinks are constructed in the report.

The coding involves :
a name object for the target book's fullname
stored in a cell
fullname1
a series of name objects for the target's sheetnames
linkpath1
="["&fullname1&"]# 'sheet name x'!"

final formulas can then be inserted which look like this:
=HYPERLINK(linkpath1001&"D5";"D5")

succes.





keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"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