Append Data to Table after Web Query
Hello,
I'd like to be able to build a table of stock quote data in Excel. I can get the data from Medved's QuoteTracker which includes an HTTP server. Using a GetLastQuote command to the HTTP server, I can get quote data for stock symbol(s) I specify. What I'd like to do is execute the GetLastQuote command, move down to next row in the table/worksheet, pause for 30/60 seconds, execute the GetLastQuote command again...and so on until I stop the macro. I'm using Excel in Office2000. TIA for your help! OmaSteak |
All times are GMT +1. The time now is 10:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com