On the latter point of an easier method, it is a good practice to setup
constant for frequently used, or variable, values. In this way, you could
have a constant for these paths, all in one easily accessible, easily
changed place.

I put my constants in an independent module, with shared code.

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"skc" wrote in 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