Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change hyperlink property to new location
We are moving users to a winows 2003 server from Novell and I am concerned
about the changes in hyperlinks to files within Office files including Word, Excel, Access etc. Also the Desktop shortcuts. You can imagine the scale of the problem with 2000 users. I would like to select a folder Identify shorcuts and change the relevant properties to point to the new location. Similarly I would like to open files , locate hyperlinks and do some sort of edit and replace on the location. I would imagine that others have come across this when migrating to a windows server. I would have expected this to be part of the Windows resource kit. Any clues would be very much appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change hyperlink property to new location
It all depends on how the hyperlinks are currently set up:
1. The easiest method is to assign a mapped drive to the server. Tell each user to assign hyperlinks to the mapped drive rather than: \\server1\Financial Reports\2006\October\summary.xls That way, when there is a block migration from one server to another, the only thing required from the users to to disconnect the mapped drive and connect it to the new server. 2. If the server/path is embedded in the individual hyperlinks, you could write a macro to search and replace each link address in each document. -- Gary''s Student - gsnu200747 "Big Mac" wrote: We are moving users to a winows 2003 server from Novell and I am concerned about the changes in hyperlinks to files within Office files including Word, Excel, Access etc. Also the Desktop shortcuts. You can imagine the scale of the problem with 2000 users. I would like to select a folder Identify shorcuts and change the relevant properties to point to the new location. Similarly I would like to open files , locate hyperlinks and do some sort of edit and replace on the location. I would imagine that others have come across this when migrating to a windows server. I would have expected this to be part of the Windows resource kit. Any clues would be very much appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change hyperlink property to new location
I was hoping that there was already some code out there for this sort of
thing. Thaks for getting back so quick -- "Gary''s Student" wrote: It all depends on how the hyperlinks are currently set up: 1. The easiest method is to assign a mapped drive to the server. Tell each user to assign hyperlinks to the mapped drive rather than: \\server1\Financial Reports\2006\October\summary.xls That way, when there is a block migration from one server to another, the only thing required from the users to to disconnect the mapped drive and connect it to the new server. 2. If the server/path is embedded in the individual hyperlinks, you could write a macro to search and replace each link address in each document. -- Gary''s Student - gsnu200747 "Big Mac" wrote: We are moving users to a winows 2003 server from Novell and I am concerned about the changes in hyperlinks to files within Office files including Word, Excel, Access etc. Also the Desktop shortcuts. You can imagine the scale of the problem with 2000 users. I would like to select a folder Identify shorcuts and change the relevant properties to point to the new location. Similarly I would like to open files , locate hyperlinks and do some sort of edit and replace on the location. I would imagine that others have come across this when migrating to a windows server. I would have expected this to be part of the Windows resource kit. Any clues would be very much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink to workbook location | Excel Worksheet Functions | |||
File Location Hyperlink | Setting up and Configuration of Excel | |||
Browsing to Hyperlink location | Excel Discussion (Misc queries) | |||
Hyperlink Location | Links and Linking in Excel | |||
Edit Hyperlink property | Excel Discussion (Misc queries) |