Ever since I’ve started working with MS Excel 2007, I’ve encountered several incidences of “out of memory” problems on a computer with 2Gig of RAM (memory).
This and this point out issues on memory limits with Excel.
I am doing pretty dodgy stuff like calling python scripts from VBA, among other things. Python is much, much nicer for parsing text files however…