I want to
copy one column at a time from excel
paste it in ERP software
come back to excel copy the next column
paste it in ERP software
and so on until a blank column appears
I have written this program but I am not able to put this in a loop
Code: Select all
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}
[Mod actions: (1) Split post to its own topic from an unrelated topic (looping in a text file). (2) Added [code][/code] tags. Please use them yourself when posting code.]