You could also direct your script to a Count subroutine like:
Sub Count()
D.Open_ "Excel_Spreadsheet", ftExcel
F("Count") = "0"
Do
If Not D.EOF_ Then
F("Count") = F("Count") + 1
D.Next_
End If
Loop Until D.EOF_
End Sub
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Heather Castillo
Sent: Friday, February 15, 2008 9:50 AM
To: [email protected]
Subject: [Talk] Row Count
Anyone happen to know a simple object/function to count the number of rows
in an excel spreadsheet from the datastation and return that as a variable?
I think I am making this way more difficult than it needs to be....
Thanks!
---------------------------------------
Heather Castillo
Module Coordinator/HPMIN Support
Information Systems
785.623.5084
HaysMedicalCenter
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
