Unfortunately, the regular Table File load doesn't allow for the wildcard in the sheet ID. I see two possible options:
1. You can standardize the Sheet IDs and settle on a single name
2. You can load Excel data using an ODBC driver for Excel. Then, you can use the ODBC command SQLTABLES to query the spreadsheet for the existing Table (Sheet) names and load the corresponding sheet. The script is slightly more complex, however it can cover multiple sheets per spreadsheet and allow different sheet names.
www.masterssummit.com - take your QlikView skills to the next level!
Just as an idea - but didnt had any success in my case (what might have had other reasons):
try to put the whole string in a variable like you would do with the file name of loading multiple excel files
e.g. for files you would use: FOR each vSourceFile in FileList (vSourcePath)
so you could try something like:
SET vSheet = '(biff, embedded labels, header is 9 lines, table is [Sheet *])';
and later in the script something like: