Please do as follow to reference the active sheet tab name in a specific cell in Excel 1 Select a blank cell, copy and paste the formula =MID (CELL I'm working on a script to search through each excel file on our network drive and parse the contents to see if it contains a social security number pattern I am In the Output property, create a Workbook variable (UiPathExcelWorkbookApplication) Then you have an assign SheetsNames = WorkbookGetSheets SheetsNames is
Microsoft Excel Create An Automated List Of Worksheet Names Journal Of Accountancy