Hi ,
I was doing the below stuff manually till now,but the volume of files are huge around 300 files.Please tell me how can I automate the process.
I have folder c:\SPD in this folder I have around 300.xls files, each xls file will have 4 to 5 tabs, in these tabs I need to replace the text from SERVER to CLIENT and I need to REPLACE the text V.1.2 to V.7.1.1, there is no fixed order of these words.
Please let me know how can I do this.
Regards,
Swathi
Bookmarks