Copy webpage to excel

[pjmsimmons]

Hi All, I have an excel file with a list of hyperlinks to various webpages in column C. Would anyone have some code that would allow me to automate the process of clicking on a hyperlink, opening the page, copying the page to a new workbook, closing the webpage, inserting a new worksheet in the workbook, opening the next hyperlink, copying the webpage to the new worksheet and repeating the process until the last hyperlink has been reached. I'm sorry I have no sample code to work from but this level of automation is beyond my skills. Although I don't have that many links, the webpages are slow in opening so I was hoping to automate the process so that I could use my time more effectively, thanks in advance to anyone who feels like taking the challenge. Best regards, Paul.