I am on SPSS V30 on Windows 11 Version 23H2.
I am 'pretty sure' this worked just fine earlier today, but I cannot import or open xlsx files any longer.
There must be something that I do wrong. What jumps to your eye?
Thanks a lot
Jos Blykers
DATASET ACTIVATE DataSet3.
GET DATA
/TYPE=XLSX
/FILE='C:\Users\005705624\Box\My Files 624 005705\Documents\2011 AOLC\AOLC\AOLC Analytics '+
'Project\Survey Consolidation\Baseline 2012-2023- rev 5-20-24 Jane ter.xlsx'
/SHEET=name 'Data'
/CELLRANGE=FULL
/READNAMES=ON
/LEADINGSPACES IGNORE=YES
/DATATYPEMIN PERCENTAGE=95.0
/HIDDEN IGNORE=YES.
>Error. Command name: GET DATA
>(2063) Error reading information for sheet.
>* Sheet Name: "Data"
>Execution of this command stops.
EXECUTE.
>Error # 105. Command name: EXECUTE
>This command is not valid before a working file has been defined.
>Execution of this command stops.
DATASET NAME DataSet8 WINDOW=FRONT.
------------------------------
Jos Blykers
------------------------------