Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hyperlinks / server / cd
I have a spreedsheet on our Novell server with several hundred hyperlinks. I
want to be able to put this on a CD and all linked files with it so that it will work from any computer not on the network. Is there a way to do this? Everytime I try to do this it keeps looking for the server and not the cd. -- MsG |
#2
|
|||
|
|||
Mark
You could try this macro to replace the server path on the hyperlinks with the CD drive (I have assumed this is D). This is untested so save the file before running this code. Sub Hyper_Change() Dim hpl As Hyperlink For Each hpl In ActiveSheet.Hyperlinks hpl.Address = "D:\" & Right(hpl.Address, Len(hpl.Address) _ - InStrRev(hpl.Address, "\")) Next hpl End Sub Hope this helps Rowan "Mark G" wrote: I have a spreedsheet on our Novell server with several hundred hyperlinks. I want to be able to put this on a CD and all linked files with it so that it will work from any computer not on the network. Is there a way to do this? Everytime I try to do this it keeps looking for the server and not the cd. -- MsG |
#3
|
|||
|
|||
Where do I insert the code?
-- MsG "Rowan" wrote: Mark You could try this macro to replace the server path on the hyperlinks with the CD drive (I have assumed this is D). This is untested so save the file before running this code. Sub Hyper_Change() Dim hpl As Hyperlink For Each hpl In ActiveSheet.Hyperlinks hpl.Address = "D:\" & Right(hpl.Address, Len(hpl.Address) _ - InStrRev(hpl.Address, "\")) Next hpl End Sub Hope this helps Rowan "Mark G" wrote: I have a spreedsheet on our Novell server with several hundred hyperlinks. I want to be able to put this on a CD and all linked files with it so that it will work from any computer not on the network. Is there a way to do this? Everytime I try to do this it keeps looking for the server and not the cd. -- MsG |
#4
|
|||
|
|||
Open the Visual Basic Editor from the menu ToolsMacroVisual Basic Editor.
Insert a new module from the menu InsertModule. Paste the code onto the module sheet that is created. Go back to your excel file and use the menus to run the macro: ToolsMacroMacros. Select Hyper_Change and click Run. Hope this helps Rowan "Mark G" wrote: Where do I insert the code? -- MsG "Rowan" wrote: Mark You could try this macro to replace the server path on the hyperlinks with the CD drive (I have assumed this is D). This is untested so save the file before running this code. Sub Hyper_Change() Dim hpl As Hyperlink For Each hpl In ActiveSheet.Hyperlinks hpl.Address = "D:\" & Right(hpl.Address, Len(hpl.Address) _ - InStrRev(hpl.Address, "\")) Next hpl End Sub Hope this helps Rowan "Mark G" wrote: I have a spreedsheet on our Novell server with several hundred hyperlinks. I want to be able to put this on a CD and all linked files with it so that it will work from any computer not on the network. Is there a way to do this? Everytime I try to do this it keeps looking for the server and not the cd. -- MsG |
#5
|
|||
|
|||
Thanks for the help. I'll give this a try.
-- MsG "Rowan" wrote: Open the Visual Basic Editor from the menu ToolsMacroVisual Basic Editor. Insert a new module from the menu InsertModule. Paste the code onto the module sheet that is created. Go back to your excel file and use the menus to run the macro: ToolsMacroMacros. Select Hyper_Change and click Run. Hope this helps Rowan "Mark G" wrote: Where do I insert the code? -- MsG "Rowan" wrote: Mark You could try this macro to replace the server path on the hyperlinks with the CD drive (I have assumed this is D). This is untested so save the file before running this code. Sub Hyper_Change() Dim hpl As Hyperlink For Each hpl In ActiveSheet.Hyperlinks hpl.Address = "D:\" & Right(hpl.Address, Len(hpl.Address) _ - InStrRev(hpl.Address, "\")) Next hpl End Sub Hope this helps Rowan "Mark G" wrote: I have a spreedsheet on our Novell server with several hundred hyperlinks. I want to be able to put this on a CD and all linked files with it so that it will work from any computer not on the network. Is there a way to do this? Everytime I try to do this it keeps looking for the server and not the cd. -- MsG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks / server / cd | Excel Discussion (Misc queries) | |||
SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
hyperlinks following in copies of original file | Excel Discussion (Misc queries) | |||
saved hyperlinks do not keep the file association, all revert to . | Excel Discussion (Misc queries) | |||
Hyperlinks Problems | Excel Worksheet Functions |