how to work with Internet explorer status bar in vba

Hi all,

how to refer internet explorer status bar in vba.

example like

if i get "some message" in internet explorer status bar, what is the vba code to write.

thanks in advance.

can any one respond on this.....please help me...

How to work with IE statusbar text?

Hi punna111

I answered an IE related question in the last few days and have modified the code for your case to learn about statusText too. I have provided the whole code rather than just the one line to obtain the statusText.
The code starts up IE, goes to webpage and whilst it is loading it prints the status text to the debug window.
You can also write to the statusText (this is not show in the code). Here is the MSDN reference that I used. http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx
Hope this helps.

Please Login or Register  to view this content.

Hi ducky,

Thank you for your help...

However i confused from above code. i am learning vba now. sorry for many questions.
i will tell you clear scenario now

if ie is showing the status bar text as "loading....." or "processing....." how i should i represent in code?

after clicked on a some button on ie with my vba macro, ie will show 2 different messages on status bar. i will get only one message from below messages for one time. i will not get two messages at a time.
1) "record done"
2) "doesn't exist"

If i get message on status bar as "record done" i need to do some events with macro.
If i get message on status bar as "doesn't exist" i need to skip that loop and need to go to next loop.

I need vba code for the above situations.

please help me......

Hi punna111

I apologise but this sounds like it's beyond my expertise but will keep playing with my code as am intrigued. Hopefully someone in the community will have the answer and direct you more appropriately.
However, I do have a few questions to clarify your request:

• Is Internet Explorer started by macro or user?
• Internet Explorer has a readystate which is an enum http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx When you mentioned "loading....." or "processing....." do you mean these readystates?
• Will you run an Excel macro that will click on a particular button on Internet Explorer which will which load another webpage with some data? Whilst loading this page will the status bar will be updated with "record done" or "doesn't exist" text?
• Can "record done" and "doesn't exist" be displayed numerous times until the webpage readystate is complete?
• You mention loops, I don't understand
  If i get message on status bar as "doesn't exist" i need to skip that loop and need to go to next loop.

Thanks.

Hi ducky,

Thank you for your reply..

i am clarifying the below things for your queries:

1) IE started by user not by macro. i used "appactivate" to activate the IE.

2) as i am new to vba, i don't know what is ready state. my macro will click on certain button on IE, then IE will show as "processing". how can i control the macro to stop going to the next line till that time (means till it get processed).

3) Yes you are right. my macro will click on certain button. and it will not open a new page. but it will make some changes on same page. after clicking on that button it will show as "processing..". after this completion it will show either "record done" or "doesn't exist" on status bar.

4) these "record done" and "doesn't exist" wil be displayed after completion of "processing...". i think this is not relates to readystate.

5) for this point i have to give some more details about my macro.

my macro is to change some documents on IE. for example cancellation of one record.
my macro will take the record no. from excel sheet and it will cancel that record. to cancel the record it will click on certain button on IE. i have taken a loop to do continuously from excel sheet. it means if i have 10 record no.s on excel sheet, if i click on macro it will cancel 10 records then it will stop.

when i am cancelling i will get one message either "record done" or "doesn't exist" on status bar. if i get record done the macro should write "done" on a particular cell and it should go to next line it means next record. if i get "doesn't exist" on status bar. the macro should take next record no. and it shouldn't go to the next line on the macro.

Sorry for long post........ please help me....