I am using an excel file to copy one column and paste it into an ERP software(JD Edwards).
The steps that I do manually to copy the data are:
copy one column from excel (ctrl+c)
change screen to JDE (alt+tab)
paste the column(ctrl+v)
hit enter in JDE
change screen to excel (alt+tab)
move to next column with enter or down arrow
with the below mentioned code I am able to paste just one column but I am not able to run this in loop till so that the data is copied from the first column till last
Code: Select all
^w::
Clipboard := ""
send, ^c
ClipWait
if (Clipboard = "`r`n")
break
send, {Alt down}{TAB}{Alt up}
Sleep 1000
Send, ^v
Sleep 1000
Send, {enter}
Sleep 1000
send, {Alt down}{TAB}{Alt up}
send, {enter}
send, {enter}