This is what I ended up using, and it works pretty slick. I should have known that. I think I got frustrated and overlooked the simple solution.
Have a great weekend! --------------------------------------- Heather Castillo Module Coordinator/HPMIN Support Information Systems 785.623.5084 HaysMedicalCenter [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) __________________________________________________ >From Bennett, Brian <[EMAIL PROTECTED]> Sent Fri 2/15/2008 10:33 AM To '[email protected]' <[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])
Important: This email and any attachments may contain confidential information subject to protection under the Federal Standards for Privacy of Individually Identifiable Health Information (45 C.F.R. Parts 160 and 164). If you or your organization is a “Covered Entity” under the above mentioned regulations, you are obligated to treat such information in a manner consistent with the regulations. If it appears that this email was sent to you in error, (1) you are prohibited from utilizing or disseminating this email or any attachments; (2) please immediately delete it from your computer and any servers or other locations where it might be stored, and email this sender or call the Hays Medical Center Privacy Officer at (785) 623-2188 advising that you have done so. We appreciate your cooperation.
