VBA Performace for Huge size (50MB) Workbooks

  • Thread starter Thread starter Alex Lai
  • Start date Start date
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
 
110MB excel files ?
and you're proud of that...

hmm...
I'd be getting worried..

have I lost my design skills
or
will I lose my data

<vbg>


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
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?
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top