Workflow Script Assistance

[theodoreivan]

Hello! I am very very new at autohotkeys, so i need some help, please!
i am trying to write a workflow script for functionality between Oracle and Excel.
What i need it to do is type COM, tab twice, send a note, save, copy, alt tab to the excel file, go six cells over from the last cell worked in, paste, go down a row and over 7 cells, copy, alt tab back to oracle, press the F11 key, tab twice, paste, alt tab back to excel, go one cell right, copy, alt tab back to oracle, tab 3 times, paste, the hit control F11.
What i tried writing is below. It is not working. i'm not sure where it is going wrong, but the chief thing i notice is that when the information is copied, it disappears from where it is copying from.

Help, please???

!+\::Send COM{TAB}{TAB} NOTE TO BE INPUT
^s
^c
!{TAB}
{RIGHT 6}
^v
{DOWN}{LEFT 7}
^c
!{TAB}
{F11}
{TAB 2}
^v
!{TAB}
{RIGHT}
^c
!{TAB}
{TAB 3}
^V
^{F11}
Return

[Johana]

Someone is probably going to tell you to use COM with excel. I don't know how. I am new to scripting my self but here is an idea (I am extremly new, so this is just temporary til someone gives you better help) . First of all you don't have sleep. You should or the computer wont have the time to run everything.
Also the last ^V you have is a capitalized V.. So basically you're telling AHK to press CTRL+SHIFT+v (the shift to capitilize the V)

Code: Select all

!+\::
SendInput,  COM{TAB 2}
Sleep, 50
SendInput, NOTE TO BE INPUT 
Sleep, 50
SendInput, ^s
Sleep, 50
SendInput, ^c
SendInput, !{TAB}
Sleep, 50
SendInput, {RIGHT 6}
Sleep, 50
SendInput, ^v
Sleep, 50
SendInput, {DOWN}{LEFT 7}
Sleep, 50
SendInput, ^c
Sleep, 50
SendInput, !{TAB}
Sleep, 50
SendInput, {F11}{TAB 2}
Sleep, 50
SendInput, ^v
Sleep, 50
SendInput,!{TAB}{RIGHT}
Sleep, 50
SendInput, ^c
Sleep, 50
SendInput, !{TAB}{TAB 3}
Sleep, 50
SendInput, ^v
Sleep, 50
SendInput, ^{F11}
return