Not really important, I am going to roll out the macro to 100+ coworkers so just want it to look clean. If it is just how it looks and there is nothing adverse happening in the background that is fine.
This worked excellently! Thanks again
Sorry, posted from the wrong window I had open. Should be this - 6 is out, and redunant variables are out
iLitigation = "No"
iMediation = "No"
For i = 18 To 24
If Sess0.Screen.getstring(i, 2, 4) = "OPEN" Then
Select Case...
This is working great, but one problem - when lines are highlighted in the box they tend to flicker or "trip out" as if something is wrong... is there anything I can do to stop it?
Otherwise perfect solution.
I'm using this an it seems to be working - anything wrong?
iLitigation = "No"
iMediation = "No"
For i = 18 To 24
If Sess0.Screen.getstring(i, 2, 4) = "OPEN" Then
Select Case Sess0.Screen.getstring(i, 10, 6)
Case "LGLLIT"...
Lakare, this looks great. I've since reformatted them into strings - if I can't figure out how to work it in I'll check back. Excellent - exaclty what I wanted!
Below for row "18" I need to also check rows 19 through 24... what would be the best way to do this?
Thanks
If Sess0.Screen.getstring(18, 2, 4) = "OPEN" Then
Select Case Sess0.Screen.getstring(18, 10, 6)
Case "LGLLIT", "DOSLIT", "LGLSCU", "6"...
I'm going to go with this unless you have a better suggestion:
I changed them all to strings and created a new string and will just display the text in a msgbox, because I don't think there is a better way.
Just wanted to post solution in case anyone reads this later.
msgtext="...
Wasn't sure if I could edit it, but it looks like I can condense it using the case for searches in the same area on the same screen - I'll do that too once I find out how to display results.
Thanks again
Skip,
I'm checking 15 different areas on 15 different screens. I have it sent to integer right now, but I'm going to swap it to string "yes" vs "no" later.
Is there a way to show all of them at once in the same box?
It may meet multiple criteria and need to know the best way to show the...
I have a macro that is reading data from attachmate and setting variables based on the data found. I could do it as an integer or string, either would work for me.
For example:
if (Sess0.Screen.getstring(2, 2, 2) = "12") then
iVA = 1
Else
iVA...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.