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