Hi All,
I don't know if anyone has noticed this before.
According to the help in Excel 2000 the maximum number of rows in a Worksheet is 65,536. Sure enough if you open an Excel Worksheet and pagedown enough you'll reach row 65,536. My problem is that I have created some automation code in VFP6.0 which outputs an Excel Worksheet and to my surprise I discovered that with automation there is a limit of 65,000 rows. As soon as I refer to row 65,001
oWorkSheet.Cells[65001,1].Value = "Hi There"
I receive the following error message 'Invalid subscript reference'.
You may be asking why would I want a Worksheet with that many rows? Answer: I don't, but I was doing some testing on how long it takes to output large amounts of data to Excel with automation and I came across this problem. I thought that it was Excel causing the problem then I remembered that VFP has as limit on array sizes. The following is from the VFP help under 'Visual FoxPro System Capacities':
Maximum # of elements per array 65,000.
This means that with automation you are limited to 65,000 rows ( I think <g> ).
Regards,
Gavin...