View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gr8guy gr8guy is offline
external usenet poster
 
Posts: 49
Default forming Ticker-Tape in Status Bar after running web Query

Hi,

I am trying to retrieve data from an external webpage which refreshes
automatically every 15 secs. It displays the list of agent ID's logged in to
our system at a particular time.

The webpage shows a data in table format similar to this:

Agent ID TimeOnCall someothercolumns


1) Is it possible to SORT the extracted data on a worksheet OR a locally
available webpage file on a network drive,

2) Show the AgentID's along with LAST TimeOnCall for that agent who logged
out, (scrolling or displayed) in the Status Bar of a Worksheet or webpage,
by which I would come to know that this agent has just logged out & is not
working? So that i can approach the agent & ask him to login again.

Any Help would be appreciated!

Thanking you in advance.

Eijaz



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 2/6/2004