Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
dconradgreen
Level I

Get Excel Worksheets XLSM

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Get Excel Worksheets XLSM

Hi,

 

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.

Brian Corcoran

JMP Development

View solution in original post

2 REPLIES 2
Highlighted

Re: Get Excel Worksheets XLSM

Hi,

 

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.

Brian Corcoran

JMP Development

View solution in original post

Highlighted

Re: Get Excel Worksheets XLSM

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.

 

Brian

Article Labels