Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

For Excel VBA expert only

God love us

Amateur
Advanced Member
Messages
134
Reaction score
0
Points
26
Hi po patulong namn po ako gusto ko sana kunin yong specific nq information from website to my excel file. Ito po code ko sa excel vba ko
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = Range("ID").Row And _
Target.Column = Range("ID").Column Then
Dim IE As New InternetExplorer
IE.Visible = True
IE.navigate "http://mpcservicedesk.maaden.com:8400/WorkOrder.do?woMode=viewWO&woID=" & Range("ID").Value

Do
DoEvents
Loop Until IE.readyState = READYSTATE_COMPLETE

Dim Doc As HTMLDocument
Set Doc = IE.document
Dim td As String
std = Trim(Doc.getElementsByTagName("td")(1).innerText)
Dim aTD As Variant
aTD = Split(std, ",")
Range("Badge").Value = aTD(1)
End If
End Sub


Tapos ito naman po yong code ng website na gusto kong pagkunan ng information lang Bagde no at grade po

<td nowrap="nowrap" width="15%">
<b><img align='absmiddle' src="/images/spacer.gif" height="22" width="1px">

Badge No
</b>
</td>


<td width="35%">

<div> <input type="hidden" id="FIXEDUDF_CHAR12" value="-1" ></input>
<input type="hidden" id="ALLOWUDF_CHAR12" value="false" ></input> <a class='spotEdit' href="javascript:void(0);" onClick="loadSimpleFields('UDF_CHAR12','SCAT_WO','104484','Single Line','5701')" val="0" id="UDF_CHAR12_CUR">0</a><div id="UDF_CHAR12_PH"></div>
</div>


<input type="hidden" id="UDF_CHAR12_MANDATORY" name="UDF_CHAR12_MANDATORY" value="true"/>
<input type="hidden" id="UDF_CHAR12_DISPLAYNAME" name="UDF_CHAR12_DISPLAYNAME" value="Badge No"/>

<div id="Badge No" class="hide">Badge No</div>
</td>


<td nowrap="nowrap" width="15%">
<b><img align='absmiddle' src="/images/spacer.gif" height="22" width="1px">

Grade
</b>
</td>


<td width="35%">

<div> <input type="hidden" id="FIXEDUDF_LONG2" value="-1" ></input>
<input type="hidden" id="ALLOWUDF_LONG2" value="false" ></input> <a class='spotEdit' href="javascript:void(0);" onClick="loadSimpleFields('UDF_LONG2','SCAT_WO','104484','Numeric Field','5701')" val="0" id="UDF_LONG2_CUR">0</a><div id="UDF_LONG2_PH"></div>
</div>


<input type="hidden" id="UDF_LONG2_MANDATORY" name="UDF_LONG2_MANDATORY" value="true"/>
<input type="hidden" id="UDF_LONG2_DISPLAYNAME" name="UDF_LONG2_DISPLAYNAME" value="Grade"/>

<div id="Grade" class="hide">Grade</div>
</td>
</tr>
<tr class='oddrow' nowrap="nowrap">



Marami pong salamat sa totolong po.
 
Back
Top Bottom