Rename sheet with file name

%3CLINGO-SUB%20id%3D%22lingo-sub-1593137%22%20slang%3D%22en-US%22%3ERename%20sheet%20with%20file%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593137%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20VB.%20I%20need%20to%20do%20following%20in%20excel%2C%20Can%20anyone%20advise%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20I%20need%20to%20convert%20binary%20to%20MS%20excel%20workbooks%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20All%2031%20sheet%20names%20should%20be%26nbsp%3B%20%22Funding%20Report%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1593137%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593278%22%20slang%3D%22en-US%22%3ERe%3A%20Rename%20sheet%20with%20file%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593278%22%20slang%3D%22en-US%22%3EWe%20need%20more%20information.%20I%20have%20no%20idea%20what%20you%20mean%20by%20%231%20and%20regarding%20%232%3A%20you%20cannot%20have%20a%20workbook%20with%2031%20worksheets%20with%20the%20same%20name.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1593292%22%20slang%3D%22en-US%22%3ERe%3A%20Rename%20sheet%20with%20file%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1593292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20mean%2031%20different%20excel%20file%20..%20Each%20is%20in%20Binary%20format%20%2C%20I%20need%20to%20change%20to%20MS%20excel%20workbook%20.%20and%20each%2031%20files%20have%20different%20excel%20sheet%20names%20.%20I%20need%20to%20change%20to%20common%20name%20%22Funding%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
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.
Highlighted

@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"