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