Your question is much too broad.Actually, it isn't really a question.It is
really a statement that you were "wondering" about something.
secondly, "5Gb of data" doesn't really mean anything.I have a report that
collects data from multiple sources.The workbook has 29 worksheets.It has
14,000 lines of vba code that generates a "Data" sheet with over 151,000 rows
and 74 columns.(over 11 million cells)
Yet this .xlsb workbook is less than 30Mb (it's 145Mb in .xlsm)I have another
workbook that has 10 sheets that only use 60 rows and 15 columns (each).and IT
is nearly a 2 Gb.The difference is: IT has graphics.
So, depending on what version of Excel you're using,what file format, what the
data consists of, and how you're using it,there are LOTS of "tricks" to access
a large collection of data.
But unless we know more about your data, there's no way to know what technique
would work.
Also: define "crash".to some people, anything that causes the program to stop
is a "crash".but especially with a large database, it could be as simple as a
variable being used for a row number being defined as an Integer instead of
"Long Integer". (Integer is limited to +/-32,767)
Another issue in Windows7 and Excel2010 is that for long program execution,
Windows puts Excel in "background" mode.(it changes Excel to a lower "priority"
so that you can do other stuff)When this happens, excel shows a "not
responding" message, even though it's still running.People often interpret this
as a "crash".
If you can provide a great deal more info (with sample data?) then I/we would
be glad to help.
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
On Monday, January 11, 2016 4:51 AM, Kat <katherine...@gmail.com> wrote:
Hi all,
I was wondering what can I write for the code with large data in vba because
the program always crash when I try to execute. The data I'm trying to deal
with is more than 5GB.
Thanks in advanced.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
