Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Copy and paste from excel to another program
#16
I still don't understand how to repeat with that formula. Here is what I want.

1. Open file in Excel
run "C:\Users\jgarnett\Documents\VBA Test.xlsx"
int hwndExcel=wait(30 WA "VBA Test")
1
ExcelSheet es.Init
2. Get cell
str cell=es.Cell("A2")
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
mou 1970 265
lef
wait 5
mou 3640 155
lef
wait 2
paste cell
wait 2
mou 2925 585
lef
wait 2
mou 2825 700
lef
wait 2
mou 2965 560
lef
wait 5
mou 1410 930
lef
wait 2
mou 2102 490
lef
wait 2
mou 3790 160
lef
wait 2
mou 820 540
lef
wait 2
paste cell
cell=es.Cell("d2")
wait 2
mou 865 620
lef
wait 1
paste cell
wait 2
mou 1155 830
lef
wait 2
;6. go back to search and repeat but next row until end of worksheet
mou 1970 265
lef
wait 5
mou 3640 155
lef
wait 2
cell=es.Cell("a3")
paste cell
wait 2
mou 2925 585
lef
wait 2
mou 2825 700
lef
wait 2
mou 2965 560
lef
wait 5
mou 1410 930
lef
wait 2
mou 2102 490
lef
wait 2
mou 3790 160
lef
wait 2
mou 820 540
lef
wait 2
paste cell
cell=es.Cell("d3")
wait 2
mou 865 620
lef
wait 1
paste cell
wait 2
mou 1155 830
lef
wait 2
;7. Close programs
clo hwndIE
clo hwndExcel


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)