QlikView Ignore If Sheet doesn't Exists

[BarbouS_]

Hello guys, I have an issue: 

I need to read 8 different excel files, but not all of them have 2 particular sheets , so in some of those files the sheets 'a' and the sheet 'b' are not present.

Is there a way to make Qlikview read all 8 excel files ignoring the fact that in some of them the sheets 'a' and 'b' are missing?

Without this I would need to get inside each file, check if the sheet 'a' and 'b' are present and If not create them, or QlikView will give me an Error.

Thanks in advance,

Arthur

Thanks in advance

[marcus_sommer]

One option would be to load the data per ODBC driver because then you could query the system-tables first to find out which sheets exists and then looping through them.

Another way would be to enable/disable ERRORMODE to continue the script-execution in the case of an error.

- Marcus