Error 1004 ...

[Russell Potter]

I'm trying to load , using VB, the contents of an online pronunciation
dictionary into an Excel spreadsheet (since I thought a spreadsheet
was a nice, easy format on which my completely computer non-
literate colleague could do his specialised processing), so the resulting
spreadsheet, when completed, would have something like 150,000
rows ...

Trouble is, my loading program reaches what seemingly random point
in its processing before crashing out with one of two "application-defined
errors" (and the actual error also seems to vary randomly): nos. 1004 and
25060 (or something like that: my memory for numbers is pretty awful

I don't know how to look up the description of a error from its number,
so I was hoping someone with a hell of a lot more knowledge about Excel
than myself could tell me the cause(s) (and possible work-arounds for)
these problems. Could these errors possibly be caused by the huge size
of the spreadsheet?

Another quick (unrelated) question: how many bits are in a VB 'Long' type?

Russell

 

[Jan Karel Pieterse]

Hi Russell,

I'm trying to load , using VB, the contents of an online pronunciation
dictionary into an Excel spreadsheet (since I thought a spreadsheet
was a nice, easy format on which my completely computer non-
literate colleague could do his specialised processing), so the resulting
spreadsheet, when completed, would have something like 150,000
rows ...

Are you sure the errors mentioned are not cause by the simple fact that
Excel only has 65536 rows?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[JE McGimpsey]

Excel has a maximum of 65536 rows, so you'll likely have to break up the
source file. There are lots of workarounds in the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*

but for a one-time import, using a text editor to divide the file into
three files seems easier.


As for bits in a VB Long. Looking up Long in VB Help (try it - it's
pretty good for versions before XL03):

Long (long integer) variables are stored as signed 32-bit (4-byte) numbers
ranging in value from -2,147,483,648 to 2,147,483,647.