User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
dconradgreen
dconradgreen
Level II

Get Excel Worksheets XLSM

Created: Aug 17, 2020 05:29 PM  |  Last Modified: Jun 9, 2023 4:35 PM (3119 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?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Get Excel Worksheets XLSM

Aug 18, 2020 08:32 AM (3092 views)  |  Posted in reply to message from dconradgreen 08-17-2020

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
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Get Excel Worksheets XLSM

Aug 18, 2020 08:32 AM (3093 views)  |  Posted in reply to message from dconradgreen 08-17-2020

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

briancorcoran
Staff briancorcoran
Staff

Re: Get Excel Worksheets XLSM

Aug 18, 2020 08:58 AM (3088 views)  |  Posted in reply to message from briancorcoran 08-18-2020

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

Recommended Articles