Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel VBA: sending output data table to created .csv file +append Options Mike Excel Discussion (Misc queries) 1 December 10th 11 12:39 PM
Can I use MS Query in Excel like an Append Query in Access Sam Wardill Excel Discussion (Misc queries) 0 April 11th 06 02:41 PM
How to Append the Data to the Master Table Shiva Excel Worksheet Functions 7 November 8th 05 05:00 AM
Append Data In Worksheet To Access Table Martin[_14_] Excel Programming 4 December 3rd 03 11:52 AM
Append Data To Access Table Martin[_14_] Excel Programming 3 December 3rd 03 08:33 AM


All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"