Enter a web, fill ID and download file

[rolo]

Hello VBA gurus!

Is there any way to let a macro do these tasks?

1. Enter http://www.degreedays.net
2. Fill weather station ID input box with "LEMD"
3. Press the button "Generate Degree Days"
4. Wait 10 seconds
5. Press the button "Download now" which appears at the top

If not VBA is it possible to do it with some kind of windows macro?

Thanks!

 

[Marc L]

Hi !

At least explain the purpose, what is after point #5, what is #6 ?‼

And if you need « Windows macro » ask in a Windows forum.

A must read : Web Scraping tutorial …
​

 

[rolo]

I don´t need to extract data from a web.
I need to open a web and download a file form it!

1. Enter http://www.degreedays.net
2. Fill weather station ID input box with "LEMD"
3. Press the button "Generate Degree Days"
4. Wait 10 seconds
5. Press the button "Download now" which appears at the top
6. Download the file to C:\Myfolder

Any suggestion?

 

[Marc L]

So what is the link with Excel ?‼

A must read : Web Scraping archives …
​