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!
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!