Forum Discussion

dynamideva's avatar
dynamideva
Copper Contributor
Aug 17, 2020

Rename sheet with file name

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. 

 

 

 

 

 

excel

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 17, 2020
    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.
    • dynamideva's avatar
      dynamideva
      Copper Contributor
      Aug 17, 2020

      JKPieterse 

       

      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"

Resources