Importation of .CSV file

[jjsiow]

Hello,

I have an excel macro that imports the last 7 days of values from a website. it can also import the present day and delete the 7th furthest day.
I have attached my macro.
the website is:

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

where the YYYYMMDD represents a specific date.


What I would need is essentially something very similar. I would like to have a button "today", that when you click you import today data onto a static sheet called "today" as well as import yesterday's data onto a sheet called yesterday.

I would also like to be able to place a specific date in a cell, for instance "20140803" and it would have a button called date, and essentially fetch rhis data for that date and paste it into a sheet called "specific date".

Your help would be mich appreciated.

[Bernie Deitrick]

For Today:

Please Login or Register  to view this content.

For Yesterday

Please Login or Register  to view this content.

For a specific Date or Date String in, say, cell A2 (formatted for YYYYMMDD if it is a date)

Please Login or Register  to view this content.

[jjsiow]

Thank you so much!

However, is there anyway of pasting the specific date on a sheet called "specific date"?

[Bernie Deitrick]

Of course

Please Login or Register  to view this content.