Hi

I need to build a data set for further analysis. I began to manually open the website and copy/paste the content, but since it would take way too much time doing this, I'd like to be able to do automatically...

Say I have a column, A, with url's for websites, would it be possible to have a macro running "for i = 1 to 4000" or so, opening the url in firefox or IE, and the by using something like "Ctrl-S or File>Save As" saving the content to a html-file or directly to a spreadsheet?