Can I make a macro that opens a website at specified times during the day?

[Malkavian]

Hey guys!

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 entry but have to wait to do it manually ~30 times during each 10 seconds windows...


This is somewhat annoying and stressful.

Do you think I could program something combining Excel and VBA where I count enter all the times (hours:min:sec), numbers to enter - and then the macro would open the website by itself at the right time and enter the right number?

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 macro on the background would open the specified website (address) at the right time (B) and enter the corresponding number (C) in the text box.

I cannot provide the actual website but it's similar to this:
foodblogsearch (DOT) com
2 tabs gets you to the text box then you enter a value and press enter.
Adapting code to my actual website will take like 2 minutes (add a few tabs and change website in code)


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!

Thanks!

[dflak]

There are two ways I can think of doing this. One is to use Get External Data / From Web form the Data Ribbon. This will create a connection. If you click on Data > Connections, select the connection and got to properties on the boxes you can select is refresh every X minutes.

The other method is to use the Windows Task Scheduler to run a macro in the workbook.

[Malkavian]

There are two ways I can think of doing this. One is to use Get External Data / From Web form the Data Ribbon. This will create a connection. If you click on Data > Connections, select the connection and got to properties on the boxes you can select is refresh every X minutes.

The other method is to use the Windows Task Scheduler to run a macro in the workbook.

Do these methods require that I have a macro constantly running in the background (like an infinite loop) so it's constantly checking if the current time is equal to one of the ~30 specified hour:min:sec?

Because I believe that would prevent me from using Excel...

Thanks!

[dflak]

The first method would require that you keep the macro running.

Using the task scheduler will open the excel spreadsheet in the background and run it for as long as it takes to download the data. You could even make as the last part of the macro, something that emails you telling you, "I'm finishing up now!"

[Malkavian]

The Task Scheduler looks like a good solution.

I've never used it though... So I'm not to sure how it would work.

The way I'm seeing it, it would be like a 2 step process :
enter the 30 hour:min:sec in the task scheduler
enter the numbers and websites to enter the numbers in the Excel file with the macro?

Thanks!