| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
info update from a webpage
How do you get information in an excel sheet to update every time you open up
the workbook. I want certain numbers to be updated from a webpage when the information on the webpage changes all the time. E.g stock quotes |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
info update from a webpage
Need,
Make a web query. Data - Import External Data - New Web Query. Then you need only refresh it (right click in it and choose Refresh). Or set up a macro in the Workbook_Open sub to do it automatically. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Need Info" <Need wrote in message ... How do you get information in an excel sheet to update every time you open up the workbook. I want certain numbers to be updated from a webpage when the information on the webpage changes all the time. E.g stock quotes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Update Info from Different Sheets? | Excel Discussion (Misc queries) | |||
| How do I set up a workbook that the worksheets update info | Excel Worksheet Functions | |||
| update info on 2 sheets @ same time | Excel Worksheet Functions | |||
| Paste Functions and Update info | Excel Worksheet Functions | |||
| How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) | |||
Linear Mode
