Excel: Generating Large Sheets

andig
05-14-2001, 11:54 AM
When generating a excel sheet via DDE from Visual Basic Program the system stops at about 6000 rows (at about 6 columns). It seems a buffer (or something else) is not large enough.

Any ideas?

SATISHNAIR
05-14-2001, 09:48 PM
is it 65000 or 6000 ?

The known fact is that one sheet can hold only 65000 rows


"Every problem has a solution or atleast a workaround - :)"

andig
05-14-2001, 10:28 PM
Sorry, but it is 6.000.
The is no error message reporting an overflow or other problems. The System just stops...

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum