I keep trying to import an individual stock price to a single cell but the
Data/Import External Data/New Web Query system seems to only allow me to
only import a whole table which of course changes my whole spread sheet.
Any suggestions on how to just import only the current stock price to a
single cell?
Ron Patterson

Import to another sheet and use a macro or indirect formula to import to
where desired. Look here.
goto
xltraders-subscribe@yahoogroups.com
and look in the files section. There are several free files.
I have a couple of free files under author donalb36

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Ron Patterson" <a.baba@mindspring.com> wrote in message
news:QOadnVzPULFXUoHVnZ2dnUVZ_qiinZ2d@earthlink.co m...
>I keep trying to import an individual stock price to a single cell but the
>Data/Import External Data/New Web Query system seems to only allow me to
>only import a whole table which of course changes my whole spread sheet.
> Any suggestions on how to just import only the current stock price to a
> single cell?
> Ron Patterson
>

Thanks for the effort Don, but macros and indirect formulas are way over
this user's head. I am lost already.
And I tried to go to xltraders-subscribe@yahoogroups.com but it is an email
address apparently, not a web page.

Any other suggestions?

Thanks,
Ron

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:uTVbHAXrIHA.4884@TK2MSFTNGP06.phx.gbl...
> Import to another sheet and use a macro or indirect formula to import to
> where desired. Look here.
> goto
> xltraders-subscribe@yahoogroups.com
> and look in the files section. There are several free files.
> I have a couple of free files under author donalb36
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguillett1@austin.rr.com
> "Ron Patterson" <a.baba@mindspring.com> wrote in message
> news:QOadnVzPULFXUoHVnZ2dnUVZ_qiinZ2d@earthlink.co m...
>>I keep trying to import an individual stock price to a single cell but the
>>Data/Import External Data/New Web Query system seems to only allow me to
>>only import a whole table which of course changes my whole spread sheet.
>> Any suggestions on how to just import only the current stock price to a
>> single cell?
>> Ron Patterson
>>
>

Here is the web site but you will have to subscribe to get any free files.
http://tech.groups.yahoo.com/group/xltraders/files/
You may send your workbook to me at the address below to have a look.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Ron Patterson" <a.baba@mindspring.com> wrote in message
news:jY-dnSTGE8TMY4DVnZ2dnUVZ_ramnZ2d@earthlink.com...
> Thanks for the effort Don, but macros and indirect formulas are way over
> this user's head. I am lost already.
> And I tried to go to xltraders-subscribe@yahoogroups.com but it is an
> email address apparently, not a web page.
>
> Any other suggestions?
>
> Thanks,
> Ron
>
> "Don Guillett" <dguillett1@austin.rr.com> wrote in message
> news:uTVbHAXrIHA.4884@TK2MSFTNGP06.phx.gbl...
>> Import to another sheet and use a macro or indirect formula to import to
>> where desired. Look here.
>> goto
>> xltraders-subscribe@yahoogroups.com
>> and look in the files section. There are several free files.
>> I have a couple of free files under author donalb36
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "Ron Patterson" <a.baba@mindspring.com> wrote in message
>> news:QOadnVzPULFXUoHVnZ2dnUVZ_qiinZ2d@earthlink.co m...
>>>I keep trying to import an individual stock price to a single cell but
>>>the Data/Import External Data/New Web Query system seems to only allow me
>>>to only import a whole table which of course changes my whole spread
>>>sheet.
>>> Any suggestions on how to just import only the current stock price to a
>>> single cell?
>>> Ron Patterson
>>>
>>
>
>

Try Smart Tags - xl2002 and later I believe.
To find out how...
Enter "Smart Tags" in the help window and choose... "Get a stock quote"
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Ron Patterson"
<a.baba@mindspring.com>
wrote in message
I keep trying to import an individual stock price to a single cell but the
Data/Import External Data/New Web Query system seems to only allow me to
only import a whole table which of course changes my whole spread sheet.
Any suggestions on how to just import only the current stock price to a
single cell?
Ron Patterson