Hi Peter

Greetings! My macro created a workbook with tons of worksheets. I revised
the macro programs instead create a workbook with just two worksheets. It
would be nice to have all the worksheets, but I rarely looked at them. They
were an intermediate result of the program. Fortunately, with the smaller
workbook, the problem has not re-occurred.
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick


"Peter T" wrote:

Looks like your workbooks, though on the largish size, are not excessive. So
it sounds like your macro is creating memory bloat or leakage. What does
your macro do, eg create lots of objects or IE instances without destroying
them as you go.

Regards,
Peter T

"MichaelDavid" wrote in message
...
Greetings! I was running an Excel Macro using Excel 2007 Home and Student.
The program ran normally for 4 hours retrieving data from the internet
using
the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My
machine
has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4
hours,
I saw the following message:
"(X) Excel cannot complete this task with available resources. Choose less
data or close other applications." In 3 years of running these macros, I
had
never seen this problem before.
At the time of this problem, System Information reported the following:
Installed Physical Memory: 1GB
Total Physical Memory: 997 MB
Available Physical Memory: 350 MB
Total Virtual Memory 1.21 GB
Page File Space 1.27 GB

At the time of the problem, COMPUTER reports that the C Drive (on which
Excel resides) has 37.3 GB free of 67.4 GB.
Three Excel workbooks were open. The largest of these is 12,856 KB. The
other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone
know
what might have caused this problem? Could it just have been a fluke? Any
and
all suggestions and comments are most welcome.
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick
--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick