Rename sheet with file name

Copper Contributor

Hi All, 

 

I don't know VB. I need to do following in excel, Can anyone advise, 

 

1. I need to convert binary to MS excel workbooks 

2. All 31 sheet names should be  "Funding Report". 

 

Thanks in advance. 

 

 

 

 

 

2 Replies
We need more information. I have no idea what you mean by #1 and regarding #2: you cannot have a workbook with 31 worksheets with the same name.

@Jan Karel Pieterse 

 

I mean 31 different excel file .. Each is in Binary format , I need to change to MS excel workbook . and each 31 files have different excel sheet names . I need to change to common name "Funding"