Error Mode = 0 not working with Excel 2010 file when sheet is missing
Hi everyone,
While looping a folder with Excel documents in load script, I'm having trouble trying to ignore an error when a sheet doesn't exist in one of the files. I have the ErrorMode = 0. The script finishes anyway and pops up the reload message box. The files are from Excel 2007/2010. Is it really the missing sheet that is causing the problem? Ther is no way of knowing what's going on and that's extremely frustrating! I can't use the sheet number because it has different content across documents: only the sheet name can be used. I'm using version QlikView version 10 32bit.
In Rob's Cook Book ( http://robwunderlich.com/downloads) there is a example of load using ODBC. This way you can check all the sheets that exist before trying to actually load them.