Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
see load script .. when i reload without actual load the excel, the TRACE will give me a list of all sheetnames .. but than i uncomment the loading of the excel, and my names of tabs are all gone .. i really give up. There must be something wrong in the comment lines
[code]
ODBC CONNECT32 TO [Excel Files;DBQ=$(vWorkbook)];
SpreadsheetData:
SQLTABLES;
FOR i = 0 to NoOfRows('SpreadsheetData')-1
LET sheetName = purgeChar(peek('TABLE_NAME', $(i), SpreadsheetData), chr(39));
TRACE --- test2 $(sheetName);
// LOAD
// @7,
// '$(sheetName)' AS Sheet
// FROM [$(vWorkbook)] (biff, no labels, table is [$(sheetName)]);
//
NEXT
[/code]
Your script works, have copy/pasted the above and only populated the vWorkbook with an existing name.
Peter