Created:
Aug 17, 2020 05:29 PM
| Last Modified: Jun 9, 2023 4:35 PM(2007 views)
I am trying to use the Get Excel Worksheets function on a Macro Enabled Excel file (.xlsm) and can't seem to get it to work. I saved the same file as a regular .xlsx and it worked like a charm with that. The Scripting Index doesn't really mention any condition of excel file type... Is this function just not compatible with .xlsm?
Unfortunately this looks like a bug in the software. I will make sure this gets fixed in JMP 16.0. The only workaround I am aware of at this time is to change the extension of the file that you are opening to xlsx (with the Macros still in the file, not saving it again) and it should return the sheet names.
Unfortunately this looks like a bug in the software. I will make sure this gets fixed in JMP 16.0. The only workaround I am aware of at this time is to change the extension of the file that you are opening to xlsx (with the Macros still in the file, not saving it again) and it should return the sheet names.
I need to qualify my response. My comments are only for the Windows version of JMP. The Mac version cannot open XLSM files. The library that we use to open Excel files there cannot handle the macro enabled format.
