Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlinks-changing the filename only!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlinks-changing the filename only!
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlinks-changing the filename only!
Hi,
I just figured out that i can use the Excel Edit Menu Replace option! Rgds, Eijaz "Frank Kabel" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlinks-changing the filename only!
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlinks-changing the filename only!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the filename in a Link | Excel Discussion (Misc queries) | |||
Hyperlinks keep changing | Excel Discussion (Misc queries) | |||
Dynamic Hyperlinks - Changing Folders and Filename | Excel Worksheet Functions | |||
link to other workbook with changing filename | Excel Worksheet Functions | |||
Changing Filename when linked to other worksheets | Excel Discussion (Misc queries) |