Just to echo what Patrick said - it seems to me that with a little
discipline, using the drive name would be more permanent than trying some
alternative like the Server name, if changing servers is the point of
concern. If you will be changing file locations, so that either or all of
Server Name and Drive letter and directory could change, then you might have
common file (or registry entries) that scripts reference to set a variable
value and use the variable in your code.

Regards,
Tom Ogilvy


"Patrick Molloy" wrote in message
...
if the file structure on the server is the same then if
you map the server to the same drive, it won't affect
your code at all.

Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Macros in Excel2000 reference directories on the network
through mapped drives, hence the map is listed in the
Macro: e.g. F:\client\new\directory
er
We are now mg servers and it is proving a problem to go
through the VB script and amend the mapped letter to
point
to a new location (I know I can do a find/replace!!)

Is there any easier method of deploying paths in Macros,
so if we go through another server change, we do not
face
any agro?

thanks,

skc
.