Saturday, September 17, 2011

XMacro Go To Website Copy Stuff from Excel and Paste

Setup
First window open is openoffice excel document
second is website
third is terminal

//Wait two seconds
Delay 2
//Open location in firefox
KeyStrRelease Control_L
KeyStrPress Control_L
KeyStrPress l
KeyStrRelease l
KeyStrRelease Control_L


String https://www.websitetouloadstuff.com

//Hit enter goes to site so wait 7 seconds
KeyStrPress Return
KeyStrRelease Return
Delay 7

//create
KeyStrPress c
KeyStrRelease c

//alt tab to excel
KeyStrPress Alt_L
Delay 1
KeyStrPress Tab
KeyStrRelease Tab
Delay 1
KeyStrPress Tab
KeyStrRelease Tab
KeyStrRelease Alt_L

//copy data
KeyStrPress Control_L
KeyStrPress c
KeyStrRelease Control_L
KeyStrRelease c

//go down a cell
KeyStrPress Down
KeyStrRelease Down

//alt tab to firefox
KeyStrPress Alt_L
Delay 1
KeyStrPress Tab
KeyStrRelease Tab
KeyStrRelease Alt_L

//paste info
KeyStrPress Control_L
KeyStrPress v
KeyStrRelease Control_L
KeyStrRelease v
Delay 1

//change loxcation
KeyStrPress Tab
KeyStrRelease Tab
KeyStrPress Tab
KeyStrRelease Tab
KeyStrPress Tab
KeyStrRelease Tab
KeyStrPress Down
KeyStrRelease Down
KeyStrPress Return
KeyStrRelease Return
Delay 5
//hit enter so load site

//save it
KeyStrPress Control_L
KeyStrPress s
KeyStrRelease Control_L
KeyStrRelease s

//rinse repeat

bash run.sh
#!/bin/bash
for (( i=0; i<4000; i++ ))
do
cat xmacro_v5.log | xmacroplay ":0.0"
done

No comments:

Post a Comment