LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Macros crash, "Not enough memory"

Hi All.........
I have an Excel file with a BUNCH of macros. The file basically takes a
downloaded database as an Excel file and imports it and massages it and
Autofilters sections of it out to 15 different sheets.......the external file
is about 1.5MB and the entire combined thing is a little over 3MB, so it's
not really huge. Problem is on this 864MB/512MBRAM machine here at work, the
program crashes near the end and gives Out of Memory error. The same file
runs fine on my 1.2GB/512MBRAM machine at home, and even on my 366MB/160MBRAM
laptop.

There is 1.7GB free on the HD of the problem machine, and nothing in the
TrashBin......no other programs running......only difference that I can see
is the problem machine is on the network at work. The home machine is on a
wireless LAN, and the laptop is independent. I get the same results on the
problem machine using XL97, 2000, and 2002.

Any ideas would be appreciated..........

Vaya con Dios,
Chuck, CABGx3


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a file with macros lead Excel to crash JorgeLMV Excel Discussion (Misc queries) 1 February 9th 07 01:58 PM
Macros Don't Show On Commands List and 'Normal.dot' SV Excel Worksheet Functions 3 December 13th 06 07:23 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
how do I run excel 4.0 macros on excel 2000 RodolfoDallas Excel Discussion (Misc queries) 1 March 12th 06 03:14 AM
Excel crashes while opening excel file imbeddied with macros ct2147 Excel Discussion (Misc queries) 0 December 30th 05 09:05 PM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"