Linking data from the Internet

[Doug Sanders]

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

 

[Gord Dibben]

2003 Data>Get External Data>New Web Query

2007 Data>From Web


Gord Dibben MS Excel MVP

 

[Doug Sanders]

2003 Data>Get External Data>New Web Query

2007 Data> From Web


Gord Dibben MS Excel MVP

Thanks for the response..

I should have added 'Excel 2003'.

Doug

 

[ryguy7272]

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