I currently have a working script to pull variables from excel and use them in another program. The problem is, the process I am using is somewhat slow. I was looking for a more efficient way, if one exists. Ideally, I would like to be able to pull a whole row of variables at once. Right now, my script goes cell to cell, copy, move from clipboard to variable, repeat to end of row, then reset to the next row.
I am self taught, so please bare with my jenky code, but an example of what I have is below:
Code: Select all
{ ; Copy HAWB
Send, {right}{right}
Sleep, 100
Send, ^c
Sleep, 100
HAWB:=RegExReplace(clipboard,"\R")
Sleep, 100
clipboard = ;
Sleep, 100
StringLower, HAWB, HAWB
Sleep, 100
}
{ ; Copy MAWB
Send, {right}
Sleep, 100
Send, ^c
Sleep, 100
MAWB:=RegExReplace(clipboard,"\R")
Sleep, 100
clipboard = ;
Sleep, 100
StringLower, MAWB, MAWB
Sleep, 100
}