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

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

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

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

.