exporting CSV from IE

Hi i am writing a code to simplify some tasks at work. there is a website that we visit regularly to get rainfall data from and its wastes allot of time filling out irrelevant data. i have written the code to open IE fill out requested data and generate tables. there is a button which opens a downloadable CSV file but for the life of me i cant get it working. my code looks like this so far

Please Login or Register  to view this content.

i have attached 2 files showing what my spreadsheet looks like at the moment and what the hirds website looks like (showing the CSV download link) Hirds.JPG spreadsheet.JPG

if anyone could point me in the right direction that would be great.

Originally Posted by Tinbendr

This doesn't answer your question directly, but, you know, you can pull that data right into Excel, without code, using Data->From Web, paste in the link 'https://hirds.niwa.co.nz/hirds_data/work/NZMG/6480256/2667674/2.1,0,0/DDF', click the four yellow arrows, click Import, point to starting cell and hit enter. Voila, all the data appears.

When you need to update, just right click, Refresh.

You can also record the web query and have the link built from the sheet data, if it changes.

Please Login or Register  to view this content.

thanks for the reply, but unfortunately the URL changes according to the address by adding the coordinates for the site to the URL as shown below in red

https://hirds.niwa.co.nz/hirds_data/work/NZMG/6480256/2667674/2.1,0,0/DDF

so unless I can pull the URL which my macro ends on into the workbook I cant use it your way.

Originally Posted by Tinbendr

This answers your original question.

Please Login or Register  to view this content.

I've uploaded a file that has either solution.

Sheet1 just d/ls the file.

Sheet2 pulls the data in through a querytable to the sheet.

Your first post got me going in the right direction (i'm just allot slower at coding), here you nailed it on the head! thanks mate! and thanks to everyone else who posted!