"Tom Ogilvy" wrote in message ...
If you put the data in the worksheet, it can be sorted.

If the list is a list of agents logged in, then you would need a list of all
agents and have to make a comparison against this list to determine who
isn't logged in.

If you want to build a test string of this write code to animate it by
removing a character from one end and adding a character to other, then you
can put this information in the status bar. Excel provides no particular
support for the animation and it would be time intensive - distracting from
you 15 sec refresh of the data in the web page.

I can't say what you can do with a web page.

--
Regards,
Tom Ogilvy

gr8guy wrote in message
...
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



This is a suggestion. If you know where the logout info is stored in
your system you should be able to (as long as your system is windows
conpatable) write a program to interface with it to look for the
required information and post it to your sreadsheet. But do this with
care.

Hope this gives you some ideals.

Charles