Excel Macro Memory Errors

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

I'm having a problem with a large Excel (version 9.0)
macro written by one of my users. Basically, the first
time it runs it gets to a certain point (where it tries to
access data in another spreadsheet) and then Excel
generates an application memory error and bombs out.
However the second (and third and fourth and fifth etc)
time it works without any problems.

The macro runs from a mapped drive on a server, but i've
tested it on various different machines (workstations and
servers, all on at least 100mb full duplex) and this
problem ALWAYS occurs. If I leave the machine that has run
the code for a couple of hours the problem reoccurs.

Has anyone encountered this before or got any suggestions?
This is beginning to get on my nerves :)

Stuart
 
Almost always a procedural or programming error. Post the details to
excel.programming

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
Microsoft Certified Professional [Windows 2000]
http://www.microsoft.com/protect


:
| I'm having a problem with a large Excel (version 9.0)
| macro written by one of my users. Basically, the first
| time it runs it gets to a certain point (where it tries to
| access data in another spreadsheet) and then Excel
| generates an application memory error and bombs out.
| However the second (and third and fourth and fifth etc)
| time it works without any problems.
|
| The macro runs from a mapped drive on a server, but i've
| tested it on various different machines (workstations and
| servers, all on at least 100mb full duplex) and this
| problem ALWAYS occurs. If I leave the machine that has run
| the code for a couple of hours the problem reoccurs.
|
| Has anyone encountered this before or got any suggestions?
| This is beginning to get on my nerves :)
|
| Stuart
 
Back
Top