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

's Computer Specifications

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 ?

's Computer Specifications

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 (E-Mail Removed)> wrote in message news:F06FD4E2-FFE7-437B-80FE-(E-Mail Removed)...
>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 ?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro in Excel to copy paste data into multiple slides in powerpoint	SK	Microsoft Powerpoint	0	3rd May 2010 11:09 AM
Need macro to allow me to go out into another excel file and copy and bring data back..	Steve	Microsoft Excel Discussion	10	20th Apr 2006 06:12 PM
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro	Steven	Microsoft Excel Programming	1	17th Oct 2005 08:56 AM
Macro to Copy & Paste a Excel file	DNKMCA	Microsoft Excel Discussion	1	4th Oct 2005 01:54 PM
Re: Macro to Copy Data Base file from Server and Paste to SpecifiedFo	Steve Schapel	Microsoft Access Macros	0	27th Jul 2004 06:05 PM