Thread: How Do I Copy a Website Page To A Sheet?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default How Do I Copy a Website Page To A Sheet?
Hi Fred

You can use Workbooks.Open

Workbooks.Open ("http://www.microsoft.com")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"FredC" wrote in message .. .
I want to copy all of the data on a webpage and paste it to an Excel spreadsheet
cell/range.

I have the hyperlink on the spreadsheet and can click it with a macro, but I
can't copy the page in the macro. It just stops when IE opens.

Would someone please offer a code snippet to put me on the track?

- Fred



Reply With QuoteReply With Quote