Hi Gary's student,
Thank you for your reply. I am attaching part of the macro. Could you
please tell me how to use it in this format.? I want to replace the word
Medway. Again thank you for your help.
ChDir "C:\2007 Client Package"
ActiveWorkbook.SaveAs Filename:= _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
thank you mac