automatic copy(with refresh) some web(specific) data into excel
$30-100 USD
Cancelado
Publicado hace más de 17 años
$30-100 USD
Pagado a la entrega
I need an automatic copy(with refresh) of some web(specific) data into excel.
the web requires a card number (equivalent to user name) and a password (i have them both -in the Deliverables screen...).
It is not trivial because you cannot get into the page automaticaly without entering the card number and the password. however, there is no problem to manualy do copy-paste of the data that I want into excel.
## Deliverables
I need an automatic copy(with refresh) of some web(specific) data into excel.
the web requires a card number (equivalent to user name) and a password (i have them both) It is not trivial because you cannot get into the page automaticaly without entering the card number and the password. however, there is no problem to manualy do copy-paste of the data that I want into excel.
go to [[login to view URL]][1], press on the butten: "online" (if it dosen't do anything go to- tools and disable pop up blocker(i think that's how it calls, my browser is in hebrew...)). On the screen that opens, press on- English, in the card number box write:
1050224645 and in the password box write:
5194125 and then press- login.
After login press: Tel-Aviv, then: trading and: maof. On the screen that opens(might take few seconds) untick the: around the money box and you'll get a big table on the lower part of the screen (which **refresh every 30 second - you can change it or stop it if you like).
I need to be able to copy this table automatically into excel every time i want: every time i press some butten and also a possibility of refresh every X seconds that i choose (dosen't have anything to do with the **refresh of the screen that i just wrote about).
You can see that if you move the mouse over the table, press it's left button and press CTRL-A it marks exactly what i want to copy.
I have Excel 2000.
## Platform
my operating system is: windows XP
my version of excel is: excel 2000