How to get HTML element with VBA in Excel? -


i have html in excel:

<form name="scform" action="online_range.aspx" autocomplete="off"> <input name="acctno" type="hidden" value="3949067512"> <table width="100%" border="0" cellpadding="3"> <tbody><tr> <td width="6%"></td> <td width="18%" align="center" valign="middle"><font color="#ffffff" face="verdana" size="1"><b>numbers</b> <td width="18%" align="right" valign="middle"><font color="#000000" face="verdana" size="1">**000,000,000,000.00**</font></td> <td width="18%" align="right" valign="middle"><font color="#000000" face="verdana" size="1">**100,100,100,100.00**</font> <td width="5%" align="center" valign="middle"><font color="#000000" face="verdana" size="1"> <!--<a href="javascript:document.scform.submit();" onmouseover="sctest('0479281963'); window.status='account details'; return true;">--> <!-- insert buildmenu - apsmith --> <script>buildmenu_scphp(0,'')</script> <a onmouseover="showmenu(event,linksetscphp[0]); sctest(479281963, 'im'); window.status='account details';" onmouseout="delayhidemenu()" href="javascript:document.scform.submit();"> <!-- end buildmenu - apsmith --> <img width="21" height="17" src="/images/detail2.gif" border="0"></a> </font> </td> </tr> </tbody></table></td> <td width="3%"></td> </tr></tbody></table></form>

i want value td 000,000,000,000.00 , 100,000,000,000.00 have no luck.

here's tried:

dim ie new internetexplorer dim doc htmldocument  set ie = createobject("internetexplorer.application")  ie.visible = true  'navigate website ie.navigate "https://secure1.bpiexpressonline.com/authfiles/login.aspx?url=/direct_signin.htm"  'loop until page load complete     doevents     loop until ie.readystate = readystate_complete  set doc = ie.document doc.getelementbyid("userid").value = range("e23").value doc.getelementbyid("password").value = range("e24").value  doc.getelementbyid("login").submit 'loop until page load complete     doevents     loop until ie.readystate = readystate_complete  'dim tb object, tr object, th object dim tb object set tb = doc.getelementsbytagname("acctno")  here? tried getelementsbyid(td)(1) , on, no luck.

by using getelementsbyid(td)(n) there's no error output wrong, can me or teach me how parse form type.

thanks in advance

as understand have difficulties constructing path desired element?

1) add id attribute table row element, be:

<table width="100%" border="0" cellpadding="3"> <tbody><tr id="row_1">

2) can use:

dim row object set row = doc.getelementsbytagname("row_1");

3) can retrieve values this:

row.getelementsbytagname("td")(1).getelementsbytagsname("font")(1).innertext

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more