Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Copy and paste from excel to another program
#17
ok so here is the macro I have came up with thanks to you! Smile

The only thing I'm working on is if the macro stops because of any reason which row did it leave off on.

1. Open file in Excel
run "C:\Users\jgarnett\Documents\December 2013 Returns.xlsb"
int hwndExcel=wait(30 WA "December 2013 Returns")
1
ExcelSheet es.Init
2. Get array
ARRAY(str) a
es.CellsToArray(a "C:T")
3,4. Open web page in Internet Explorer
int hwndIE
web "http://www.exi.com" 1 "" "" 0 hwndIE
4. Password
AutoPassword "jgarnett" "12345" 1|4 hwndIE 10
5. Navigate to form
wait 5
mou 1990 990
lef
wait 2
int r
for r 0 a.len
mou 1970 265
lef
wait 5
search
mou 3640 155
lef
wait 2
paste a[0 r]
key T
key "o"
key Y
wait 2
clo
wait 2
account history
mou 2102 490
lef
lef
wait 5
New Inquiry
mou 3790 160
lef
wait 2
key T
key T
key T
key T
wait 2
paste a[0 r]
wait 1
key T
wait 1
paste a[17 r]
wait 2
key T
key D
wait 1
save inquiry
mou 1155 830
lef
wait 2

clo hwndIE
clo hwndExcel


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)