Set Excel Open Method to "Select Individual Worksheets" in JMP 11.1.1
Aug 15, 2014 1:18 PM(4785 views)
In JMP 10 I could use the argument "Excel Selection(1)" with the "Set Preferences()" function to override the user preferences and prompt the user for which Excel worksheets should be imported from an Excel workbook. According to the JMP 11.1.1 Help this argument should still exist as a boolean but I have determined that it no longer functions to change the preferences. Does anyone know if there is a new argument I can use to change this preference in JMP 11.1.1?