How to get the name of the active sheet in excel. I have an excel file with many sheet names but depending upon the situation only one name will come when we open the excel file. Is there any way we can get the active /current excel sheet name.?
FYI: i cannot use workbook.getsheet and loop it and get each name. What ever sheet name comes first while opening it must be displayed.
I tried using workbook.currentsheet.name but gets error " Object reference not set to an instance of an object."
While using workbook.getworkbooksheet(index) im getting the sheet name but is there any way we can get name name instead of this method?
Can we do this without interacting with excel?
I know that we can copy the sheet by opening the excel file but like (getworkboot sheet) is there any VBA script that we can use to get the active sheet name?