Excel: Creating a Macro to open CSV files and pasting on a sheet.

Hello, i was wonder is there was any way I could go to the following website: https://www.ieso.ca/imoweb/pubs/marketReports/daily/PUB_GenPlan_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!

This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of July 11, 2014.

For more resources for Microsoft Excel