One of the more interesting legacy methods on interacting with Excel is through the macro language that was supplied in older versions - Excel 4 XLM. The challenge of using XLM is simply that it has been deprecated for so long it's pretty hard to actually find documentation or find anyone who remembers how to use it. However, I have found XLM lurking around in dark corners of firms where "someone wrote this spreadsheet way back and we don't know how it works but it's mission critical"...
So to enumerate the XL4 Macro sheets in a workbook follow these steps:
- Download the code from github
- Create a new Excel workbook with one worksheet
- Save the new workbook as an xlsm format workbook
- Enter the VBA editor
- Import the module you just downloaded from github
- Execute the "EntryPointListXL4MacroSheets" method and look in the debug window
- Since you don't have any XL4Macro sheets in the workbook, add some using "Sheets.Add type:=excel.XlSheetType.xlExcel4MacroSheet"
- Now execute the "EntryPointListXL4MacroSheets" method and look in the debug window