Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rows in Excel2000 limited to 65000 with automation
Message
From
02/10/2002 22:04:08
 
 
To
02/10/2002 21:49:50
Gavin Reid
L & M Marketing Pty Ltd
Frenchs Forest, Australia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00707180
Message ID:
00707184
Views:
21
This message has been marked as the solution to the initial question of the thread.
Hi, Gavin.

>This means that with automation you are limited to 65,000 rows ( I think <g> ).

This code works for me:
Local oWorksheet as "excel.application"
oWorkSheet = CreateObject("excel.application")
oWorkSheet.Visible=.t.
oworkSheet.Workbooks.Add()
oworksheet.Cells[65001,1].Value = "Hi There"
Claudio Lassala
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform