| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get data from an internet page through a macro?
R
If you know the URL to the site, paste it into a cell as a hyperlink on a worksheet. Use the macro recorder to record the steps as you click on that hyperlink, go to the site, EditSelect AllEditCopy then return to Excel and InsertWorksheet. Select a cell(say A1) and EditPaste SpecialText. Stop recording. Gord Dibben Excel MVP On Fri, 14 May 2004 13:41:04 -0700, "R" wrote: I would like to write a macro which opens up an internet page, copies all the information and pastes it onto a spreadsheet. What is the code for opening the explorer application and copying all the data on a specific site? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW CAN I UPDATE DATA FROM INTERNET WITHOUT RUNNING MACRO | Excel Discussion (Misc queries) | |||
| Macro to get file off the internet | Excel Worksheet Functions | |||
| internet connection via excel macro at timed intervels & save data to excel file. | Excel Worksheet Functions | |||
| MAKING EXCEL AS HOME PAGE IN INTERNET EXPLORER | Excel Discussion (Misc queries) | |||
| Can't update the data from internet while running macro | Excel Programming | |||
Linear Mode
