Paste web page into workbook

Hi, I have some code that opens a web page and enters two input boxes then submits the entries and a value is returned to the web page. I wanted to return the value to a work sheet but my knowledge is limited so I thought I'd copy and paste the web page into a worksheet instead but it doesn't appear to work. Nothing is pasted. Any help would be greatly appreciated. Thanks in advance.