Corrupt Ex 2003 workbook via VBA and crashes

N

Nigel D kelly

opening 100 new worksheets in excel 2003 everything fine.
Load a VBA macro that I have developed Excel crashes at
different points when opening new workbooks. Try opening
100 new worksheets while the VBA macro is idle and
typically 1 in 10 sheets are corrupt specifically columns
c-e have various colours and various border settings.
While the macro has been working ok the majority of times
when I subsequently re-open the files it has created some
cannot open due to file corruption and the data is lost.

automatic repair fails but I have repaired from the
original disk.

XP SP1 (Tablet)
P4 2ghz 767meg

Any help would be great.

Nigel D kelly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top