View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Blue Blue is offline
external usenet poster
 
Posts: 7
Default Increment File Name by 1

I have 52 files, one for each week of the year, and one blank master. When
a change is required the master is updated then the files are over written
for the weeks to come, this is done manually one file at a time. The file
names are
RC1 WK1
RC1 WK2
etc
Is it possible to save the blank master as RC1 WK? to RC1 WK52, ? being the
first file to start from, over writing the previous files?

Thanks Blue