Error Mode = 0 not working with Excel 2010 file when sheet is missing

[#1]

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.

Anybody with similar problem?

[erichshiino]

Hi,

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.

There are many more great examples in that page

Hope this helps,

Erich