ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Append Data to Table after Web Query (https://www.excelbanter.com/excel-programming/289610-append-data-table-after-web-query.html)

OmaSteak

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