Copy data from an HTML file and paste into excel using a macro
 

I am trying to automate a data collection process. For this purpose I
manually select and copy all data from an html file and paste into excel. I
want to automate this with a macro. Sofar I have managed to open the html
file via a macro but how do I then the copying of all the file data in the
macro ?

Copy data from an HTML file and paste into excel using a macro
 

Hi Karl

You can try this

Sub test()
Workbooks.Open "http://www.rondebruin.nl/tips.htm"
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Karl S" <Karl wrote in message ...
I am trying to automate a data collection process. For this purpose I
manually select and copy all data from an html file and paste into excel. I
want to automate this with a macro. Sofar I have managed to open the html
file via a macro but how do I then the copying of all the file data in the
macro ?