| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
| Excel 2007 and Paste Special with HTML and data from the web | Excel Discussion (Misc queries) | |||
| On a DDE Linked worksheet : Copy and Paste Value to a to a file via a macro ? | Links and Linking in Excel | |||
| 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 | Excel Programming | |||
| Select File Copy/Paste Macro Help.... | Excel Programming | |||
Hybrid Mode
