View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silvie Silvie is offline
external usenet poster
 
Posts: 1
Default Wanting to automate: Change name of several excel documents

I have several excel documents (templates) all with the name
xxx_Testprotocol1, xxx_Testprotocol2 etc. For each test campaign I need to
replace the xxx at the beginning with the name of the testcampaign e.g.
RC27_Testprotocol1.

Is there a way of automating this since doing it manually is quite time
consuming.

Cheers
Silvie