How To Read Sheet Name Of An Excel File Help Uipath Community Forum
The most common way of getting the sheet if you only have the codename as a string seems to be to use a loop VBA Code Sub getCodeName() Dim ws As Worksheet Dim sSheet As String sSheet = A1 For Each ws In ActiveWorkbookWorksheets If wsCodeName = Range("A1")Value Then sSheet = wsName Exit For End If Next ws MsgBox "Sheet NameIn the screen shot above, the CodeName for the sheet with a tab name of Budget is Sheet3 A sheets CodeName is always the name not inside the parenthesis when looking in the Project Explorer We can reference this sheet with VBA code in the Workbook by using Sheet3Select as apposed to Sheets ("Budget")Select or Sheets (3)Select