overflow-how big a file can Excel handle?
 

When trying to run a vb script, I got an error message saying
overflow. The file is about 4 Mb with about 35900 rows and 6
columns. I had to cut half of the rows and pasted them to a new
file. Then, the script ran without problems. It seems to me that
Excel hit a limit on the file size, row number or something.

I wonder if the problem is due to my computer or Excel. Anyone has
any idea?

overflow-how big a file can Excel handle?
 

"overflow" is generally more a variable than a memory problem.

e.g. using an integer to loop thru ranges...
will error out at 32k (the maximum positive value of an integer.

change variable to a long should fix it.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


John Smith wrote :

When trying to run a vb script, I got an error message saying
overflow. The file is about 4 Mb with about 35900 rows and 6
columns. I had to cut half of the rows and pasted them to a new
file. Then, the script ran without problems. It seems to me that
Excel hit a limit on the file size, row number or something.

I wonder if the problem is due to my computer or Excel. Anyone has
any idea?

overflow-how big a file can Excel handle?
 

Everything you ever wanted to know but were affraid to ask..

http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"John Smith" wrote:

When trying to run a vb script, I got an error message saying
overflow. The file is about 4 Mb with about 35900 rows and 6
columns. I had to cut half of the rows and pasted them to a new
file. Then, the script ran without problems. It seems to me that
Excel hit a limit on the file size, row number or something.

I wonder if the problem is due to my computer or Excel. Anyone has
any idea?