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]
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]