Extract data from Internet Explorer

rprosser

New Member
Joined
Sep 28, 2006
Messages
10
Hi,

I’m a frequent visitor to the site and have found it VERY helpful (I thank all of you who post back) but I have never posted before, so please be patient with me if I’m not explaining something very well.

I have been working with VBA for a few years now and I feel comfortable with it and I’m trying to expand my horizons by communicating with Internet Explorer which I’m not too comfortable with. With that said, here is what I’m trying to accomplish:

I have code communicating to a website and it’s seems to be working well. However, what I want to do is extract a portion of text from the site but I’m not sure how to do it. Below is a portion of the source code from the website where I need to extract the data.

I have the code extracting the entire “textarea” but what I want to do is extract the very last note in the message log Sent : 09/28/2006 11:25:00 AM I think it's bolded and underlined.

Here is portion of my VBA code extracting the entire text area:

GetValue = myIE.Document.getElementById("TextArea").Value


Thanks for the help!




<TR>
[/B]</TD>
</TR>
<TR>
<TD>
<CENTER>
<TEXTAREA NAME="TextArea" ROWS="9" COLS="80">

FROM : BATI, LISA      Date Sent : 09/21/2006 8:27:35 AM
Status Code : A
Status Description : ASSIGNED TO PREPARER
Subject : UPGRADE / FEE AJUSTED
Message : Fee has been adjusted to reflect allowable amount for an upgrade based on the 04/01/06 revised fee schedule.
Date Received : 21, Sep, 2006 - 11:09


FROM : BATI, LISA      Date Sent : 09/21/2006 8:27:17 AM
Status Code : A
Status Description : ASSIGNED TO PREPARER
Subject : Status Change: XP to A
Message : Status changed from EXCEPTION - MANUAL ASSIGN(XP) to ASSIGNED TO PREPARER(A) , Changed by BATI, LISA(439646) at Sep 21 2006 8:27AM
Date Received : 21, Sep, 2006 - 11:09


FROM : SYSTEM      Date Sent : 09/21/2006 7:10:21 AM
Status Code : A
Status Description : ASSIGNED TO PREPARER
Subject : Status Change: I to XP
Message : Status changed from INCOMING (NEW)(I) to EXCEPTION - MANUAL ASSIGN(XP) , Changed by SYSTEM at Sep 21 2006 7:10AM
Date Received : 21, Sep, 2006 - 11:09


FROM : SYSTEM      Date Sent : 09/21/2006 7:09:41 AM
Status Code : A
Status Description : ASSIGNED TO PREPARER
Subject : Status Change: to I
Message : Status changed from () to INCOMING (NEW)(I) , Changed by SYSTEM at Sep 21 2006 7:09AM
Date Received : 21, Sep, 2006 - 11:09


FROM : SYSTEM      Date Sent : 09/21/2006 8:38:10 AM
Status Code : M
Status Description : ACCEPTED ON LINE
Subject : Status Change: A to M
Message : Status changed from ASSIGNED TO PREPARER(A) to ACCEPTED ON LINE(M) , Changed by SYSTEM at Sep 21 2006 8:38AM
Date Received : 21, Sep, 2006 - 11:09


FROM : SYSTEM      Date Sent : 09/21/2006 8:38:10 AM
Status Code : M
Status Description : ACCEPTED ON LINE
Subject : Status Change: A to M
Message : Status changed from ASSIGNED TO PREPARER(A) to ACCEPTED ON LINE(M) , Changed by SYSTEM at Sep 21 2006 8:38AM
Date Received : 21, Sep, 2006 - 12:09


FROM : [AP]
     Date Sent : 09/28/2006 9:25:55 AM
Status Code : M
Status Description : ACCEPTED ON LINE
Subject : Delayed
Message : 9/28 78579746. Borrower requested this order be placed on{LF} hold until they can speak to lender. Please{LF} advise how to proceed with this order. Thank{LF} you, LSI Sent: 09/28/2006 12:23:55 PM EDT
Date Received : 28, Sep, 2006 - 12:09


FROM : [AP]
     Date Sent : 09/28/2006 9:25:55 AM
Status Code : M
Status Description : ACCEPTED ON LINE
Subject : Delayed
Message : 9/28 78579746. Borrower requested this order be placed on{LF} hold until they can speak to lender. Please{LF} advise how to proceed with this order. {LF} , : 09/28/2006 12:23:55 PM EDT
Date Received : 28, Sep, 2006 - 02:09


FROM : JORDAN, JEANETTE      Date Sent : 09/28/2006 11:24:27 AM
Status Code : M
Status Description : ACCEPTED ON LINE
Subject : Hold to LP Declining Access
Message : The Appraisal Resource Center has been notified that our appraiser can not complete the requested service due to the following reason: Borrower Decline Access/ Not Ready -- Borrower requested this order be placed on hold until they can speak to lenderTherefore, we have placed the status of this service on ?Hold?. This order will remain on ?Hold? for up to 30 days pending the resolution of the issue listed above. If the information listed above is not received, this request will cancel automatically after the 30th day. -----Original Message-----From: [AP] : 9/28/2006 9:25:55 AMSubject: Delayed9/28 78579746. Borrower requested this order be placed on{LF} hold until they can speak to lender. Please{LF} advise how to proceed with this order. Thank{LF} you, LSI Sent: 09/28/2006 12:23:55 PM EDT
Date Received : 28, Sep, 2006 - 02:09


[b]FROM : JORDAN, JEANETTE      Date Sent : 09/28/2006 11:25:00 AM
Status Code : H
Status Description : HOLD
Subject : Case on Hold
Message : Change date/time:9/28/2006 11:24:59 AMChanged by:JORDAN, JEANETTE prsn_pk:479864Hold Reason:Borrower Declined Access/Not ReadyStatus changed from: ACCEPTED ON LINE to HOLD
Date Received : 28, Sep, 2006 - 02:09
[/b] </TEXTAREA>
</CENTER>
</TD>
</TR>

</TABLE>

[/b[/url]
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Joined
Jul 30, 2006
Messages
3,656
Welcome to the board.

"I have the code extracting the entire “textarea” but what I want to do is extract the very last note in the message log Sent : 09/28/2006 11:25:00 AM I think it's bolded and underlined."

Of the data in your scroll box, please show us all the information that makes up the very last note.


Have a great day,
Stan
 

rprosser

New Member
Joined
Sep 28, 2006
Messages
10
The rest of the note

HI,

Thanks for the reply and help. Here is the last note as well as the data that appears after it.





FROM : JORDAN, JEANETTE      Date Sent : 09/28/2006 11:25:00 AM
Status Code : H
Status Description : HOLD
Subject : Case on Hold
Message : Change date/time:9/28/2006 11:24:59 AMChanged by:JORDAN, JEANETTE prsn_pk:479864Hold Reason:Borrower Declined Access/Not ReadyStatus changed from: ACCEPTED ON LINE to HOLD
Date Received : 28, Sep, 2006 - 03:09


</TEXTAREA>
</CENTER>
</TD>
</TR>

</TABLE>





<HR ALIGN="CENTER">
</P>





<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" WIDTH="100%">
<TR>
<TD ALIGN="RIGHT">
<INPUT type="BUTTON" NAME="NewSearch2" value="New Search" onclick="ActionPath(this);">
</TD>
</TR>
</TABLE>

<INPUT TYPE="HIDDEN" NAME="Submit" VALUE="">
<INPUT TYPE="HIDDEN" NAME="ServerIPAddress" VALUE="http://webcluster.lendersservice.com:33500/boainfo/NavSer ">
<INPUT TYPE="HIDDEN" NAME="NullMessageInfo" VALUE="FALSE">






</FORM>

</BODY>

</HTML>
 

Forum statistics

Threads
1,137,366
Messages
5,681,074
Members
419,950
Latest member
BeckiJae

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top