Hi Rob

Thanks for your reply

See, what i mean is i get the agentId's in Suppose Col A, and their logged in time in Col B
I want to collect the AgentID's & Logged-in-Time in variables(or an array for each Column A & B) & then
pass them to the TickerTape function which will display them scrolling one - after - the other across the length of the Statusbar, either from left to right direction or from right to left direction
similar to a scrolling Marquee on a webpage which travels horizontally across the webpage

after the 15 sec refresh, new data will be loaded by webQuery, in the columns A & B on the worksheet & that would be taken in the variables(or array) and then passed to TickerTape function which will show the AgentID's & their logout time, one-after-the-other scrolling across the length of the statusbar

Could you please convert the Javascript code which i submitted to VBA for me inorder to get the same effect which it shows on the webpage

And what about the Excel error (excel generated errors......will close......a log file has been created). do you why its happening? is it because of version of IE used(IE 4.0) or because of the particular webpage i am accessing, which is on our company intranet

Best Regards

Eija


----- Rob van Gelder wrote: ----

I did! I didn't see a lot of difference between the one I wrote and th
Javascript version
Specifically, what is different that's upsetting you? I'm at a loss

--
Rob van Gelder - http://www.vangelder.co.nz/exce


"gr8guy" wrote in messag
..
Try the one i sent you
Paste it into a notepad & save as scroll.html. You will see th
difference
I am not able to convert it to VBA code
Rgds
Eija
"Rob van Gelder" wrote in messag
..
I don't know what you did differently, but the version at my end scroll
an
isn't scrambled
TickerString = "...eijazs - 1:05 am ....... hzaki - 1:1
am.....saireen - 1:12am........rocka - 1:15 am........jeank - 1:2
am........eijazs - 1:05am....
-
Rob van Gelder - http://www.vangelder.co.nz/exce
"gr8guy" wrote in messag
..
Hi Rob
A very good morning to you
The difference is evident. the one which you supplied is located i
th
bottom left side of status bar and does not scroll across status ba
bu
appears a scrambled name. and the one which i provided (javascript)
scroll
ACROSS the status bar, probably because of the spaces in front an
afte
text. The need for a scrolling text message is
1) a scrolling marquee cannot be created in a worksheet itself, as i
i
a
array of cells (like a scrolling marquee in a webpage)
2) i need it like that because there would be many agents gettin
logge
out, so their AgentId & time on which they logged out would reflect i
th
scrolling text msg (from left to right, or right to left) across th
statu
bar. So I would be able to see (for some time) the no of agents logge
ou
in the current duration. the ticker-tape would hold variables fo
suppos

agents & run, till further agents get logged out & then the variable
woul
automatically be updated with the new AgentIDs & run along status bar
S
probably, if no agents logged out the last agents IDs would show i
th
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
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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.583 / Virus Database: 369 - Release Date: 2/10/2004