N
Nigel D kelly
Opening 100 new workbooks 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 workbooks while the VBA macro is idle and
typically 1 in 10 books 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.
This only appear to occur when I initially run a copyrecordset to extract 2 dates from an access database and pass them over to the initial userform. manually insert those dates in the form (comment out copyrecordset) and no problems are seen.
XP SP1 (Tablet)
P4 2ghz 767meg
Any help would be great.
Load a VBA macro that I have developed Excel crashes at
different points when opening new workbooks. Try opening
100 new workbooks while the VBA macro is idle and
typically 1 in 10 books 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.
This only appear to occur when I initially run a copyrecordset to extract 2 dates from an access database and pass them over to the initial userform. manually insert those dates in the form (comment out copyrecordset) and no problems are seen.
XP SP1 (Tablet)
P4 2ghz 767meg
Any help would be great.