Also, I don't know about everyone else, but depending whom you get the data from, we not only have to check for D.EOF, but DataStation will sometimes read a blank cell as "", so need to check for D(column) = "" as well.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> - 717.972.8123 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bennett, Brian Sent: Friday, February 15, 2008 11:33 AM To: '[email protected]' Subject: RE: [Talk] Row Count 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 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
