Hi, I need to extract data from csv files from a website. The files are created daily and are listed on webpages split by category and then by year (i.e. /website address/category1/category2/filenamedate.csv)
There is a login page for the website and I need to download the data from multiple csv files (only two cells for each file) into once single file giving me a time series of data. I'm using Excel 2007 on Windows XP and using Internet Explorer 6.
Thanks in advance for any help.
There is a login page for the website and I need to download the data from multiple csv files (only two cells for each file) into once single file giving me a time series of data. I'm using Excel 2007 on Windows XP and using Internet Explorer 6.
Thanks in advance for any help.