On Jun 26, 12:35 pm, J@Y wrote:
I am importing a large text file into Excel using MS's macro (ie: creating
mulitple worksheets)
After about 1 million lines, I get this error message saying I don't have
enough resources to complete the task. I have about 2 gigs for physiscal
memory and 3 gigs of virtual memory. What exactly is the resources refering
to?

You already posted this message not even 30 minutes ago. Be patient
and try not to add more posts than necessary.

I'm not sure how you are interacting with your text file, but keep in
mind that Excel has a row and column limitation to it (depending on
the version of Excel you have). Also, the more data you have (i.e.
lots of row, column data or lots of worksheets), the more resources
Excel needs to keep track of where all of the data is. If you are
adding hundreds of worksheets than you can expect Excel to get bogged
down.

Matt