Malkavian
09-08-2016, 11:29 AM
Hi!
Everyday, ~30 times a day, I need to go on a website and enter a specific number in a text box.
I have to do it on average 30 times a day and only have a window of 10 seconds to do it every time.
Each morning I have all the information for my ~30 data entries but have to wait to do it manually 30 times during each 10 second windows...
This is somewhat annoying and stressful.
Do you think I could program something combining Excel and VBA when I count enter all the times (hours:min:sec) and numbers to enter?
The Excel worksheet could look like something like this:
Address (A): Time (B): Number (C):
www abccc/111111 com 10:32:23 87.345
www abccc/222222 com 11:42:20 88.546
www abccc/333333 com 14:11:05 88.578
www abccc/444444 com 16:32:29 89.157
www abccc/555555 com 16:39:55 84.523
www abccc/666666 com 18:58:26 83.178
And each morning I could fill all 3 columns and some VBA coding on the background would open the specified website (address) at the right time (B) and enter the corresponding number (C) in the text box.
Do you think that could be done?
If you think there is already a program that could do just that or if you can think or a better way of doing this, please let me know!
Everyday, ~30 times a day, I need to go on a website and enter a specific number in a text box.
I have to do it on average 30 times a day and only have a window of 10 seconds to do it every time.
Each morning I have all the information for my ~30 data entries but have to wait to do it manually 30 times during each 10 second windows...
This is somewhat annoying and stressful.
Do you think I could program something combining Excel and VBA when I count enter all the times (hours:min:sec) and numbers to enter?
The Excel worksheet could look like something like this:
Address (A): Time (B): Number (C):
www abccc/111111 com 10:32:23 87.345
www abccc/222222 com 11:42:20 88.546
www abccc/333333 com 14:11:05 88.578
www abccc/444444 com 16:32:29 89.157
www abccc/555555 com 16:39:55 84.523
www abccc/666666 com 18:58:26 83.178
And each morning I could fill all 3 columns and some VBA coding on the background would open the specified website (address) at the right time (B) and enter the corresponding number (C) in the text box.
Do you think that could be done?
If you think there is already a program that could do just that or if you can think or a better way of doing this, please let me know!