Is it possible to create a macro that gets CSV files online?

[jjsiow]

Hello,

i was wonder is there was any way I could go to the following website:

https://www.ieso.ca/imoweb/pubs/mark...n_20140711.csv

and copy paste it into an excel sheet. What i would need is to get this page and the previous 7 days by changing the date "20140711" to "20140710" and so on. Each orevious day needs to be copy pasted to a different sheet.

As a new day occurs, I would like to delete the page 7 days ago and add the new day on a new sheet.
I hope this is clear enough.

Thank you!

[Marc L]

Hi,

just notice Excel can open a csv file like a xls* workbook file, even via an url !

Do it in Excel and via the Macro Recorder you'll get a code to start with !

[jjsiow]

Hello,

I'm sorry but I am having trouble following what you are telling me?

[Marc L]

When you open a workbook, instead of selecting the workbook local path,

just paste the URL of the csv file !