hyperlinks-changing the filename only!

[Frank Kabel]

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.

 

[gr8guy]

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

 

[gr8guy]

Hi,

I just figured out that i can use the Excel Edit Menu > Replace option!

Rgds,

Eijaz

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

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

 

[gr8guy]

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

 

[keepitcool]

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 >