| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking data from the Internet
Please guide me if I'm in the wrong group, I don't want to cross post
unnecessarily. I want to modify a working Spread sheet to pull stock values from the internet and plug them into cells. Has this been done and can someone show me an example? It would save me hours of work each week. Thanks, Doug Sanders |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking data from the Internet
2003 DataGet External DataNew Web Query
2007 DataFrom Web Gord Dibben MS Excel MVP On Tue, 05 Jan 2010 16:07:52 -0800, Doug Sanders wrote: Please guide me if I'm in the wrong group, I don't want to cross post unnecessarily. I want to modify a working Spread sheet to pull stock values from the internet and plug them into cells. Has this been done and can someone show me an example? It would save me hours of work each week. Thanks, Doug Sanders |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking data from the Internet
On 1/5/2010 4:49 PM, Gord Dibben wrote:
2003 DataGet External DataNew Web Query 2007 Data From Web Gord Dibben MS Excel MVP On Tue, 05 Jan 2010 16:07:52 -0800, Doug wrote: Please guide me if I'm in the wrong group, I don't want to cross post unnecessarily. I want to modify a working Spread sheet to pull stock values from the internet and plug them into cells. Has this been done and can someone show me an example? It would save me hours of work each week. Thanks, Doug Sanders Thanks for the response.. I should have added 'Excel 2003'. Doug |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Linking data from the Internet
It's easy, Doug. Turn on the macro recorder, do what Gord said, and turn off
the macro recorder. Look at this: http://www.mrexcel.com/tip103.shtml Experiment with that scenario. When you get comfortable with it, record a macro and attach it to a command button, like this: http://www.mrexcel.com/tip068.shtml -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Doug Sanders" wrote: On 1/5/2010 4:49 PM, Gord Dibben wrote: 2003 DataGet External DataNew Web Query 2007 Data From Web Gord Dibben MS Excel MVP On Tue, 05 Jan 2010 16:07:52 -0800, Doug wrote: Please guide me if I'm in the wrong group, I don't want to cross post unnecessarily. I want to modify a working Spread sheet to pull stock values from the internet and plug them into cells. Has this been done and can someone show me an example? It would save me hours of work each week. Thanks, Doug Sanders Thanks for the response.. I should have added 'Excel 2003'. Doug . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update data from internet | Excel Worksheet Functions | |||
| Newbie - can I get into excel data from the Internet? | Excel Discussion (Misc queries) | |||
| Exporting data from Excel to the internet | Excel Discussion (Misc queries) | |||
| Getting Data for excell off of the internet | Excel Discussion (Misc queries) | |||
| Getting Data from the Internet to Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
