Hi DaveSzt,

Do you actually have any sheetnames over 31 characters long, is that
possible in your version? If not include something like:

if len$(sheetname) 31 then can't do

Regards,
Peter T




"daveszt" wrote in
message ...

We have an issue where we are trying to scan Excel Spreadsheets to
retrieve their details.

We have succeeded in doing this however we get an error on some
spreadsheets. The error is as follows:

"An error occurred while loading 'Sheet6211111111111111111111111111'.
Do you want to continue loading the project?"

We can click no to this message however we are scanning somewhere in
the region of 500 000 excel sheets and we get this message around 200
times within the whole system. We cannot leave the process running
overnight without someone being here to click 'no' when the error
appears.

Does anyone know an automated way that we manage this error message? We
have looked at Microsoft Issue number '826836'
(http://support.microsoft.com/default...b;en-us;826836) but
this doesn’t seem to resolve the problem.

Thanks.

DaveSzt


--
daveszt
------------------------------------------------------------------------
daveszt's Profile:
http://www.excelforum.com/member.php...o&userid=22799
View this thread: http://www.excelforum.com/showthread...hreadid=375545