I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel?
(PS: The office is mac version.)
Try using the following macro:
For me - works quite well.
To get the same as above but additionally with hyperlinks taking you to the sheet: