Seems that you may not be looking for code on how the datastation works, but
how to advance to the next row after reading two columns so you can read the
next row.
In Magic I pretty much manually walk down the rows reading each column until I
am at the bottom of the data window. for example:
If Rule("Application [EMAIL PROTECTED],1&@3,13<mailto:[EMAIL
PROTECTED],1&@3,13>") Then ' V = 1 to how many visible rows you have
than I float between two different variables on the last row until the view is
blank
V("1") = Trim$(View(Row:=1, Col:=1, Length:=2))
Wait 0.2
V("2") = Trim$(View(Row:=1, Col:=5, Length:=8))
Wait 0.2
Key "{Down}"
end if
If Rule("Application [EMAIL PROTECTED],1&@4,13<mailto:[EMAIL
PROTECTED],1&@4,13>") Then
V("3") = Trim$(View(Row:=1, Col:=1, Length:=2))
Wait 0.2
V("4") = Trim$(View(Row:=1, Col:=5, Length:=8))
Wait 0.2
Key "{Down}"
End If
Using Key "{down}" until I am at the bottom of the window, then I use a
combination of two or three steps to make sure I am not re-reading the same
data again and again. (Since this is not a problem from the top down as there
is almost always a blank line at the bottom, but it is a problem from the
bottom up, once you get to the top the data will never change. adding a counter
(if I read this so many times exit) works well.)
If your looking for code let me know can send you snippets of both the down and
the up walks.
It's not that difficult, but it sure is a pain when there are 50 rows of data
only 7 are visible.
Brian Bennett
Affinity Health Systems
Systems Analyst
PBS\Clinic Billing
(920)628-9055
[EMAIL PROTECTED]
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2008 1:42 PM
To: [email protected]
Subject: [talkbws] reading columns & rows in excel
I am working on a script that requires me to read two different columns and the
advance a line and read the next line. This would continue until the two
columns no longer have a value.
I have scripted one column but never two different ones and then advance one
line and repeat the process.
Has anyone ever done this before? Got any tips ?
Thanks
Kelly Jones, Systems Support Analyst
Information Systems - Application Development
Methodist Health System
[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
214-947-1907
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [EMAIL PROTECTED]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
***********************************************************************
This electronic transmission contains information from Methodist Health
System and should be considered confidential and privileged. The
information contained in the above messages is intended only for the
use of the individual(s) and entity(ies) named above. If you are not
the intended recipient, be aware that any disclosure, copying,
distribution, or use of this information is prohibited. If you receive
this transmission in error, please notify the sender immediately by
return e-mail. Methodist Health System, its subsidiaries and
affiliates hereby claim all applicable privileges related to the
transmission of this communication.
---
To post a message to this list, send mail to: [email protected]
You are currently subscribed as: [EMAIL PROTECTED]
Unsubscribe in the customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
