Re: forming Ticker-Tape in Status Bar after running web Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: gr8guy (aries31031974_at_hotmail.com)
Date: 02/11/04 

Date: Wed, 11 Feb 2004 07:09:34 +0530

Hi Rob,

A very good morning to you.

The difference is evident. the one which you supplied is located in the
bottom left side of status bar and does not scroll across status bar but
appears a scrambled name. and the one which i provided (javascript), scrolls
ACROSS the status bar, probably because of the spaces in front and after
text. The need for a scrolling text message is :
1) a scrolling marquee cannot be created in a worksheet itself, as it is an
array of cells (like a scrolling marquee in a webpage).
2) i need it like that because there would be many agents getting logged
out, so their AgentId & time on which they logged out would reflect in the
scrolling text msg (from left to right, or right to left) across the status
bar. So I would be able to see (for some time) the no of agents logged out
in the current duration. the ticker-tape would hold variables for suppose 3
agents & run, till further agents get logged out & then the variables would
automatically be updated with the new AgentIDs & run along status bar. So
probably, if no agents logged out the last agents IDs would show in the
scrolling ticker-tape.

e.g. scrolling like this:
...eijazs - 1:05 am ....... hzaki - 1:10 am.....saireen -
1:12am........rocka - 1:15 am........jeank - 1:25 am........eijazs -
1:05am....

I dont know if its a great or stupid idea, but there should be a workaround
of creating a code which would find the agents logged out & the
corresponding time they logged out from the refreshing webpage.

I have never dealt with web-queries before & finding it difficult as to how
to create a code or a work-around which would show the agents logged out.
And right now, i am getting a stupid error when i access the webpage: "excel
has generated errors and will close the application. a log file has been
created."
Do you know why this is happening?

Is there any way we can workout a codable solution for my problem?

Best Regards,

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

Relevant Pages

  • Re: Slide Bar jumps the view
    ... 'Smooth Scrolling' which you need to check. ... of the slider bar to adjust the iimage to where you want. ... LiveScrolling setting and setting it to 1 will allow you to see ...
    (microsoft.public.word.newusers)
  • Re: Horizontal scrolling in Project
    ... > Is there a way to control the horizontal scrolling speed in MS ... If you only have a few bars you wish to drag, ... Then drag the bar to the right but do not go ...
    (microsoft.public.project)
  • Re: Page #s in Roman Numeral
    ... can see roman numerals when scrolling is if the page number format is set to ... It's the scroll bar page numbers that are in Roman ... I am scrolling up and down through the document looking for a specific ... "Suzanne S. Barnhill" wrote: ...
    (microsoft.public.word.docmanagement)
  • Re: forming Ticker-Tape in Status Bar after running web Query
    ... Rob van Gelder - http://www.vangelder.co.nz/excel ... > bottom left side of status bar and does not scroll across status bar but ... The need for a scrolling text message is: ... > corresponding time they logged out from the refreshing webpage. ...
    (microsoft.public.excel.programming)
  • Re: Slide Bar jumps the view
    ... I've never tried horizontal scrolling narrower than the windows). ... 'Smooth Scrolling' which you need to check. ... > effect of changing nothing UNTIL you let go of the bar, ...
    (microsoft.public.word.newusers)