Import Data from Webpage

[kosti]

Hi, I need to pull data from a webpage once a day, however the web address will differ every day that I run the program. The only difference in address is the final part which uses a date. I was wondering if there was any way to tweak the code to use the date I need (which will always be yesterday's date). Here is the code I have using what I need for today (notice yesterday's date in the URL). Tomorrow I will need data from that website but ending "2015-01-06"....the next day will need "2015-01-07"....and so on.

Please Login or Register  to view this content.

[mgs73]

This will give you the URL with yesterday's date formatted as yyyy-mm-dd

Please Login or Register  to view this content.

[kosti]

Brilliant thank you!!