I have VBA code to create workbook:
Set wb_Source_01 = Workbooks.Add
Set wb_Source_01 = xl.Workbooks.Open(FileName)
Set ws_Source_01 = wb_Source_01.Sheets("Sheet2")
Set ws_Source_04 = wb_Source_01.Sheets("Sheet1")
I want to rename the " Sheet2" as "Completed" and "Sheet1" as "InComplete"
Please advise me the VBA code to do that.
Your prompt response would be highly appreciated.