renaming a single excel sheet using multiple names in the same directory

1 processed 10 documents and created a excel file to store the values but, i get only the values of 10th document in the excel sheet, hence i moved the excel sheet of first document before writing the values of 2nd. now i have to rename the 1st excel file so that the 2nd excel which is generated during process should not overwrite the 1st one while moving it to the same folder.. can anyone help me in this.

the values of all the documents are required, i cannot change my base coding so need a coding to rename the excel files. the names should be changed from 1 to 10 dynamically

[Image Analyst]

I don't understand. Can you answer these questions?

1. How many workbooks do you have? (1 or 10 or some other number) A workbook is an Excel file that may have one or more "worksheets" inside it.
2. How many worksheets are inside each workbook?
3. What are the workbook name(s)?
4. What are the worksheet name(s)?
5. Do the data from the 10 documents go onto one worksheet each, one workbook each, or all 10 are on one worksheet in one workbook?
6. Do you want to change the name of the workbook file , or of the worksheet(s) inside the workbook?
7. What is "base coding" and why can't you change it? (If it's an m-file you should be able to change it to do what you want, right?)

[RAMESH MUNIRATHINAM]

i have one workbook. 4 sheets are linked with it. each data in the sheets are interrelated. i have 10 objects. while processing 1st object workbook is filled with datas in all sheets, while processing 2nd object the datas are replaced on the workbook...

[RAMESH MUNIRATHINAM]

so i planned to move the workbook of 1st processing before writing the data of 2nd process while moving the 2nd workbook, since 1st and 2nd workbook has the same name 1st is replaced with the second

i need to give dynamic renaming of workbook after moving it to the specific folder

after a long struggle i got outputs so if i touch the variables, again i should reorganize the program structure. that is not possible at the moment

[RAMESH MUNIRATHINAM]

workbook name : points 1st processed data will be saved in that workbook after 2nd processing values in workbook will be replaced

so i moved the workbook to another folder then during processing of 3rd document, the second workbook is moved to same folder as first since 1st and 2nd moved workbook has same names again the workbook is replaced

so i have to give dynamic renaming as 1 for 1st and 2 for 2nd and upto 10 to save all 10 processed datas

[RAMESH MUNIRATHINAM]

i want to change the name of workbook dynamically. once the processing of first is over and before starting the second one manually i cant change since the processing of documents are continuous