vba how to go to webpage and select the export to excel button

[greg.begin]

I am trying to write some vba to go to this page and click the export to excel icon. does anyone know how to do that. here is the web page.
https://www.hudhomestore.com/Listin...derbyValue=ASC&sPageSize=20&sLanguage=ENGLISH

 

[Deepak]

Why VBA to just download the file.

Check with the link.Just double click & voila done.

https://www.dropbox.com/s/9dt3xphj4tnopah/Export.rar

 

[greg.begin]

What was that anyway. It got exactly what I wanted but no idea what it is.

 

[greg.begin]

Why VBA to just download the file.

Check with the link.Just double click & voila done.

https://www.dropbox.com/s/9dt3xphj4tnopah/Export.rar

Is there a way to do this for other similar websites? just want data tables to do analysis on.

 

[Deepak]

Pls share the url & will update you if would possible.