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/