Rename excel file

[rahulshewale1]

Dear all sir,

Please fidn the attached screen shot of Excel worksheet.i have to Rename worksheet name every month .

example: Suppose worksheet is Posting Reports 01 Aug 2016 i want rename only month to Sep

 

[Marc L]

Hi,

from Excel menu, just use Save As …
​

 

[xlstime]

Hi Rahul,

I think you are talking about Workbooks not worksheet

It can be done using by VBA (FileObjectSystem) or command line (CMD)

Dear all sir,

Please fidn the attached screen shot of Excel worksheet.i have to Rename worksheet name every month .

example: Suppose worksheet is Posting Reports 01 Aug 2016 i want rename only month to Sep

 

[bobhc]

If you only have a few files then go to the directory, as per your screen shot, right click on a file and select rename.
if you have many, in the hundreds then install a batch re namer, there are many that are free and will do what is needed.