The maximum number of rows you can export to Excel is 65535. If you need more, use the CSV export. This was already a constraint at runtime in previous versions, but now turned into a property of the button.
To me it just stopped at row #500 and it took me awhile to figure out how to do this even that it is extremely simple... but remember that the MaxRows property must be set/defined before data is put into the spreadsheet otherwise it has no effect.
Dim i as Long
With vaSpread1
.MaxRows = 65535
For i = 1 to 15000
.row = i
.col = 1
.Text = "Text to spreadsheet"
Next i
.ExportToExcel strPath, strSheetName, "log.txt"
End With
Please see this answer from a general point of view in VB and not from a Mendix-related point of view.
Hth Jess, c++ specialist on unsafe vb ground