Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Counting rows of an Excel 97 worksheet
Message
 
To
23/12/2000 09:30:04
Charles Richard
Nvo Management Systems
Boisbriand, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Re: Counting rows of an Excel 97 worksheet
Miscellaneous
Thread ID:
00456575
Message ID:
00458535
Views:
13
The following works in Excel 2000. I haven't tried it in 97.

lnTotalRows = oExcel.ActiveSheet.UsedRange().Rows.Count

>Can someone tell me if an Excel 97 object (CreateObject('Excel.Application')...) has a property to indicate the actual number of rows and columns containing data?
Shane Murdoch
Previous
Reply
Map
View

Click here to load this message in the networking platform