Excel macros run out of memory in Windows Vista

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

horsepro001 - 29 May 2008 03:12 GMT

Please help. My new Dell laptop came with Windows Vista. I transferred some
Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my
new laptop. Those spreadsheets were created in Windows XP and are the heart
of my business. Their macros, though voluminous, ran fast and perfectly in
XP. Now, on my laptop, they can't even finish their processing due to running
out of memory. My laptop has three gigs of RAM whereas my 5-year-old desktop
has only 512k. How can I get my macros to fully run within my laptop? Thank
you.

Reply to this Message

Tim Williams - 29 May 2008 05:05 GMT

What version(s) of Excel ? XL2007 is reported to be slower than previous
versions.

Hard to say anything else without seeing any code or knowing what the macros
are doing...

Tim

> Please help. My new Dell laptop came with Windows Vista. I transferred
> some
[quoted text clipped - 9 lines]
> Thank
> you.

Reply to this Message

Geoff - 29 May 2008 22:00 GMT

As Tim says, it's hard to know what the problem is without knowing more about
what the code does, but one possibility is that if, for instance, the macros
performed some kind of loop over the entire sheet/workbook, they may be doing
a lot more work in XL2007 than in XL2003 (assuming these are the Excel
versions you are going to and from). That is just a guess though...

Signature

There are 10 types of people in the world - those who understand binary and
those who don't.

> Please help. My new Dell laptop came with Windows Vista. I transferred some
> Excel spreadsheets from my Windows XP desktop computer (also a Dell) to my
[quoted text clipped - 4 lines]
> has only 512k. How can I get my macros to fully run within my laptop? Thank
> you.

Reply to this Message