Excel 2003 Workbook Issue

  • Thread starter Thread starter daveszt
  • Start date Start date
D

daveszt

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.aspx?scid=kb;en-us;826836) but
this doesn’t seem to resolve the problem.

Thanks.

DaveSzt
 
Haven't seen the problem myself, but you could try preceding the code with

Application.DisplayAlerts = False

it might take the default action then with no popup
 
If you use Application.DisplayAlerts = False, don't forget to follow the
code with:

Application.DisplayAlerts = True

Otherwise, Excel will not prompt you to save changes when you close a
worksheet - something that many users rely on.

Tim
 
Tim,

Not disagreeing that it is a good practice, but to quote help
If you set this property to False, Micorosoft Excel sets this property to
True when the code is finished, unless you are running cross process code.

Although clearly that only takes affect at the end of the code.
 
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
 
Back
Top