View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default Insert text into filename

I have a folder full of files that I open, modify and then save to
another folder, all done by a macro. I'd like the macro to rename the
files, taking the old name and adding Mod to the name. So if the old
file is "xyz.xls" I'd like it to be "xyz Mod.xls".
I appreciate your help.