T
tcb
There is a routine that normally runs fine. It imports data from
an .xls into Access. On one occasion the code would break, but I
hadn't been able to track down the error. The import would fail.
A user tried cutting the spreadsheet data from the original .xls,
pasted it into a new .xls, ran the routine and the data imported just
fine.
This suggests that the the original .xls was corrupt in some manner.
If that is the case, and if this were to happen again, is there any
way I could trap the error?
The original .xls file appears and acts just fine in all other regards.
an .xls into Access. On one occasion the code would break, but I
hadn't been able to track down the error. The import would fail.
A user tried cutting the spreadsheet data from the original .xls,
pasted it into a new .xls, ran the routine and the data imported just
fine.
This suggests that the the original .xls was corrupt in some manner.
If that is the case, and if this were to happen again, is there any
way I could trap the error?
The original .xls file appears and acts just fine in all other regards.