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

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
.