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" 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?

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?
>