This is the code, i need it to react to initials 2-3 characters, when it encounters etc. "HL" or "FTE" it need to Press Enter (Skip the line)
(Using the code to refresh cells in microsoft excel)
SetFocus>Microsoft Excel - Ugerapport*
Wait>0.5
Let>t1=1
Let>x=1
Label>loop1
Let>t2=1
Label>loop2
Press F2
Press Tab
Let>t2={%t2%+1}
If>%t2%loop2
EndIf
Press Enter
Press Home
Press Ctrl
Send>ccc
Release Ctrl
Wait>0.1
GetClipBoard>checkvalue
Press Esc
Length>%checkvalue%,clen
If>%clen%>5
MidStr>%checkvalue%,1,5,newcheck
Else
Let>newcheck=%checkvalue%
EndIf
If>%newcheck%=I alt
Press F2
Press Tab
Press Enter
Press Home
Let>x=x+1
EndIf
If>%x%loop1
EndIf
Any help is appreciated.
Newbie help =)
Moderators: Dorian (MJT support), JRL
when it encounters etc. "HL" or "FTE" it need to Press Enter (Skip the line)
Code: Select all
GetClipBoard>checkvalue
MidStr>%checkvalue%,1,3,newcheck
//when it encounters etc. "HL" or "FTE" it need to Press Enter (Skip the line)
If>{ (Pos("HL",%newcheck%)=1) OR (%newcheck%="FTE") }
Press Enter
Endif
Thanks for the quick reply, but i does not work like i wanted it to.
Dont know if im pasting it in the wrong place in the code ?
(Looks like it's still refreshing the excel line[A18:K18], when it encounters initials)
- Let me know if you want more info, or screenshots or whatever =) Im happy to help all i can.
Hope u reply.
Bonus question ^_-
I need it to react to about 7 initials etc. "RD" "FK" "SUS" "MS" "SJ"
Dont know if im pasting it in the wrong place in the code ?
(Looks like it's still refreshing the excel line[A18:K18], when it encounters initials)
- Let me know if you want more info, or screenshots or whatever =) Im happy to help all i can.
Hope u reply.
Bonus question ^_-
I need it to react to about 7 initials etc. "RD" "FK" "SUS" "MS" "SJ"
Thanks for the quick reply, but i does not work like i wanted it to.
Dont know if im pasting it in the wrong place in the code ?
(Looks like it's still refreshing the excel line[A18:K18], when it encounters initials)
- Let me know if you want more info, or screenshots or whatever =) Im happy to help all i can.
Hope u reply.
Bonus question ^_-
I need it to react to about 7 initials etc. "RD" "FK" "SUS" "MS" "SJ"
Can i just paste em in like :
If>{ (Pos("RD",%newcheck%)=2) OR (%newcheck%="FK") OR (%newcheck%="MS") OR (%newcheck%="SUS") }
Press Enter
- Sorry to spam the forum hehe, but i just found out, that the script works fine, i just need to add more initials.
Also just realized that it does press enter, but keep on refreshing the whole excel line [A18:K18], I dont know if you can bypass the original loop, because it casuses the script to refresh it all.
Dont know if im pasting it in the wrong place in the code ?
(Looks like it's still refreshing the excel line[A18:K18], when it encounters initials)
- Let me know if you want more info, or screenshots or whatever =) Im happy to help all i can.
Hope u reply.
Bonus question ^_-
I need it to react to about 7 initials etc. "RD" "FK" "SUS" "MS" "SJ"
Can i just paste em in like :
If>{ (Pos("RD",%newcheck%)=2) OR (%newcheck%="FK") OR (%newcheck%="MS") OR (%newcheck%="SUS") }
Press Enter
- Sorry to spam the forum hehe, but i just found out, that the script works fine, i just need to add more initials.
Also just realized that it does press enter, but keep on refreshing the whole excel line [A18:K18], I dont know if you can bypass the original loop, because it casuses the script to refresh it all.