Hi All,
I have a strange issue where an Open will run successfully in JMP 16.1.0, but will fail when run in JMP 17.0.0. I am running the same .jsl file in both cases.
The code below fails when run on JMP 17.0.0. The error occurs on the Open, with a log message of "Cannot open table in access or evaluation of 'Open' , Open/*###*/(dt2, Worksheets( "PD cPCR" ), Table Contains Column Headers( 1 ),
invisible)"
The file being selected is an Excel file, and the worksheet being selected has 21,000+ rows. Trying some trial and error, I'm able to open the file if I delete all rows except for a few. Leaving in 1000 rows still results in the error.
Does anyone have ideas for further troubleshooting? Unfortunately, I can't share the file here without significant and time-consuming scrubbing/anonymization.
dt2 = pick file ("Pick cPCR reference file", "C:\JMP\");
dt2 = Open(dt2,
Worksheets("PD cPCR"),
Table Contains Column Headers( 1 ),
invisible
);