I received xls files, and these files have many sheets. Last sheet in file is incorrect. How ignore this sheet?
How are you loading all the sheet of workbook?
I use following loop
FOR j=0 TO NoOfRows('tables')-1
Simply make it :
FOR j=0 TO NoOfRows('tables')-2
So it will ignore the last sheet. give it a try.
go through this:
In this simply ignore the last sheet from the loop and try to number your sheets as 1,2,3.....
Retrieving data ...