I am trying to figure out a way to be able to input a stock ticker int
a MS Excel data cell and then create a macro that will use the ticke
from the cell to input it into a web page in order to import the stoc
table information for that particular stock.

Up till now I have been having to go about this the manual way (Data -
Import external Data - New Web Query....) and it gets a bit tim
consuming. There must be an easier way.

Has anybody else tried to create something like this? It doesn't see
like it would be that hard, but I am having a heck of a time trying t
figure this one out...

I am using OfficeXP on Windows XP Platform.

If anyone has any suggestions, or can point me in the right direction
Please let me know...Thanks for the help

--
Message posted from http://www.ExcelForum.com

pjw23,
Isn't there a .Requery or refresh method of the querytable. Or you set the
refresh rate in the querytables properties.

Nick

"pjw23 " wrote in message
...
I am trying to figure out a way to be able to input a stock ticker into
a MS Excel data cell and then create a macro that will use the ticker
from the cell to input it into a web page in order to import the stock
table information for that particular stock.

Up till now I have been having to go about this the manual way (Data -
Import external Data - New Web Query....) and it gets a bit time
consuming. There must be an easier way.

Has anybody else tried to create something like this? It doesn't seem
like it would be that hard, but I am having a heck of a time trying to
figure this one out...

I am using OfficeXP on Windows XP Platform.

If anyone has any suggestions, or can point me in the right direction,
Please let me know...Thanks for the help.


---
Message posted from http://www.ExcelForum.com/

Not sure what you are tying to say!!!

What I'm trying to do is import data from the web through the use of a
macro. The macro will lookup a value from the spreadsheet and use that
value to obtain a webpage about the particular stock.

There is already a way to do it using the built-in "MSN MoneyCentral
Investor Stock Quotes.iqy". The problem is I don't want to use this
data, I am trying to get a more detailed quote that is in a better
format. The contents of the built in .iqy file look like this...
----start----
WEB
1
http://moneycentral.msn.com/investor...es.asp?SYMBOL=["QUOTE","Enter
stock, fund or other MSN MoneyCentral Investor symbols separated by
commas."]

Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
----end----

When I try and change the site with the one I would like to use I run
into problems. If anybody has any ideas please let me know...It's
really starting to drive me crazy.


---
Message posted from http://www.ExcelForum.com/

This is what I am trying to do

http://support.microsoft.com/default...b;en-us;211926

The option that uses data from a cell field....ANy ideas..

--
Message posted from http://www.ExcelForum.com

pjw23,
Use your macro to set the cell values that the query is expecting as
parameters, once your query points to the correct web page.
Which problems are you running into ?

NickHK

"pjw23 " wrote in message
...
This is what I am trying to do

http://support.microsoft.com/default...b;en-us;211926

The option that uses data from a cell field....ANy ideas...


---
Message posted from http://www.ExcelForum.com/