Greetings, Thanks for pointing this out - Excel is notorious for this. It's something with how Excel tells us its info.
Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Visit us in Booth 2471 at HIMSS08 - February 25-28 in Orlando, FL Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx> up for my weekly webinar! LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bettio, Jason Sent: Friday, February 15, 2008 11:38 AM To: [email protected] Subject: RE: [Talk] Row Count 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. <mailto:[EMAIL PROTECTED]> [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 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
