Importing website source code into excel

Is there a way to import the source code of a website into excel?

I can do this manually by going to a website, then selecting "View" --> "Source" and then copying and pasting this text into excel. I wondering if there is a macro command that can do this for me automatically everyday.

Once i have the data in excel, I'll be able to extract what i want. I've looked at the web query function in excel but the data i want isn't always in table form.

Cheers
Schwizer

This is usually sufficient. Let me know if it is not...

Please Login or Register  to view this content.

Works most excellent. Thank you for the quick response.

Cheers
Schwizer

Hi great code, but it seems to put the source code it in an text box, any way to put it in the actual spreadsheet?