Hyperlinks / server / cd

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

Open the Visual Basic Editor from the menu Tools>Macro>Visual Basic Editor.
Insert a new module from the menu Insert>Module. Paste the code onto the
module sheet that is created.

Go back to your excel file and use the menus to run the macro:
Tools>Macro>Macros. 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

Thanks for the help. I'll give this a try.
--
MsG


"Rowan" wrote:

> Open the Visual Basic Editor from the menu Tools>Macro>Visual Basic Editor.
> Insert a new module from the menu Insert>Module. Paste the code onto the
> module sheet that is created.
>
> Go back to your excel file and use the menus to run the macro:
> Tools>Macro>Macros. 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