excel - Click on a link-botton in a web page and download-save csv file using vba -

excel - Click on a link-botton in a web page and download-save csv file using vba -

i have been trying different approach table/data this page using excel vba without result. lastly effort is, using excel vba, open web page click on csv , save file in given location.

any help much appreciated.

here's example. should far "save" dialog box.

sub anotherexample() dim url string dim ieapp object dim iedoc object dim ieform object dim ieobj object dim objcoll collection url = "http://www.bmreports.com/bsp/bmrssystemdata.php?pt=ddad&zt=n&dt=nrt" set ieapp = createobject("internetexplorer.application") ieapp.visible = true ieapp.navigate url while ieapp.busy 'wait... wend set iedoc = ieapp.document each ele in ieapp.document.getelementsbytagname("span") if ele.innerhtml = "csv" doevents ele.click 'at point need save document manually ' or figure out how automate interaction. end if next ieapp.quit end sub

i not know how automate "save" interaction, although 100% can done, i'm not inclined spend time learning how you.

excel vba web-scraping