VBA Performace for Huge size (50MB) Workbooks

S

ste mac

Alex Lai said:
ANy tips?

Hi Alex,
I have work books in excess of 110meg in excel 2000 and don't have
any problems at all....all the VBA works fine...

seeya ste
 
G

Guest

I've been having similar problems with a 19mb Excel that expands to 50mb at
times. Office products are becoming huge memory hogs. The fact that I can zip a
20 or 50 mb Excel file into 4megs tells you the program is not using memory
that efficiently. The size is do to rows. Between some of the autocorrect
options and all the formating, bloat is becoming a real issue. I would not
trust a 100 mb Excel file. I don't like them going over 5 megs. As for
programming, I've built enormous systems with hundreds of macros under 1 meg.
And Access XP is also getting larger. I'm tempted to start writing things down
to comma seperated text, or using an older system like Foxpro. How can you
manipulate data that maxes your machines resources?
[email protected]
 
Top