Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
linking script for hyperlinks for excel
Does anybody know how to set up a linking script, so to speak, for Excel? I
have a link path to 500 folders that incrementally goes up by one number. 0000, 0001, 0002-0500. I am trying to avoid making 500 separate links and only running a script to create links and only having to change the last 4 numbers by hand. Adobe has a function with linking script and exporting bookmarks and links. Please let me know if you have any idea to help. Thank you in advance, Steph |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
linking script for hyperlinks for excel
You could use a routine like this in Visual Basic
Sub Hyperlink() Range("A1").Select For A = 1 To 100 linknm = "C:\Documents and Settings\username\My Documents\Book" + CStr(A) + ".xls" ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ linknm, TextToDisplay:=CStr(A) ActiveCell.Offset(1, 0).Select Next A End Sub -- Paul Cordts "Steph" wrote: Does anybody know how to set up a linking script, so to speak, for Excel? I have a link path to 500 folders that incrementally goes up by one number. 0000, 0001, 0002-0500. I am trying to avoid making 500 separate links and only running a script to create links and only having to change the last 4 numbers by hand. Adobe has a function with linking script and exporting bookmarks and links. Please let me know if you have any idea to help. Thank you in advance, Steph |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
linking script for hyperlinks for excel
Dumb question - how do I use a routine on column A? Sorry for the ignorance
but I am not an Excel expert barely user friendly. I just knew there was an easier way to do what I have been doing for 2 weeks. Any help will be helpful. Thank you. "Paul Cordts" wrote: You could use a routine like this in Visual Basic Sub Hyperlink() Range("A1").Select For A = 1 To 100 linknm = "C:\Documents and Settings\username\My Documents\Book" + CStr(A) + ".xls" ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _ linknm, TextToDisplay:=CStr(A) ActiveCell.Offset(1, 0).Select Next A End Sub -- Paul Cordts "Steph" wrote: Does anybody know how to set up a linking script, so to speak, for Excel? I have a link path to 500 folders that incrementally goes up by one number. 0000, 0001, 0002-0500. I am trying to avoid making 500 separate links and only running a script to create links and only having to change the last 4 numbers by hand. Adobe has a function with linking script and exporting bookmarks and links. Please let me know if you have any idea to help. Thank you in advance, Steph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Linking hyperlinks to email | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
creating hyperlinks linking to other worksheets | Excel Discussion (Misc queries) | |||
Linking Hyperlinks into different cells | Excel Discussion (Misc queries) |