Posts by Yash20

Yash20 · Jul 18th 2016

Re: Unable to click on a link from webpage

Below is the entire source code, I want to find the href and vba code should click on this link

HTML

<HTML>
<HEAD>
        <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
      <META HTTP-EQUIV="Expires" CONTENT="Tue, 10 Jan 2002 04:13:09 GMT">
<STYLE>
    A {font-size: 8pt;
    font-family: "Geneva","Verdana","Tahoma","Arial","Helvetica","Sans-serif" ; }
    FONT {font-size: 8pt;
    font-family: "Geneva","Verdana","Tahoma","Arial","Helvetica","Sans-serif" ; }
</STYLE>
<SCRIPT>
    
</SCRIPT>
<script language="JavaScript">
function onSelect(medianumber,secno,language,safety){
    setFocus(secno,'');
    document.form1.Mediano.value = medianumber;
    document.form1.secno.value = secno;
    document.form1.Language.value = language;
    document.form1.SectionSafetyIndicator.value = safety;
    document.form1.submit();
}




function onSelectForSRI(psidSRI) {
    setFocusSRI(psidSRI);
    document.form3.PsidSRI.value = psidSRI;
    document.form3.submit();
}
function setFocusSRI(psidSRI){
    document.form4.psidSRI.value = psidSRI;
    document.form4.action = document.form4.action + "#" + psidSRI;
    document.form4.submit();
}








function setFocus(secno,flag){
    document.form2.secno.value = secno;
    document.form2.loadflag.value = flag;
    document.form2.action = document.form2.action + "#" + secno;
    document.form2.submit();
}
function onSelectOne(medianumber,secno,language){
    if(document.form1.canloadthirdframe.value=false && document.form1.datasourceloaded.value=="false") {
        document.form1.action="/sisweb/sisweb/datasource/datasource_prompt_page.jsp?redirectservlet=&returnpage=&methodval=&cancelbuttonreqd=false";
    }
    document.form1.action="/sisweb/sisweb/mediasearch/media_c1.jsp";
    document.form1.submit();  //populate the third frame.............
    
}
function onSelectOneSRI(psid){
    if(document.form3.canloadthirdframe.value=false && document.form3.datasourceloaded.value=="false") {
        document.form3.action="/sisweb/sisweb/datasource/datasource_prompt_page.jsp?redirectservlet=&returnpage=&methodval=&cancelbuttonreqd=false";
    }
    document.form3.action="/sisweb/sisweb/sri/sridata.jsp";
    document.form3.submit();  //populate the third frame.............
    
}




</script>
</HEAD>
<BODY BGCOLOR="#FFFFCC" LINK="#CC6600" VLINK="#CC6600" ALINK="#CC6600" >
<FORM name="form1" method="POST" action="/sisweb/servlet/cat.cis.sis.PController.CSSISMediaServlet" target="media_c" ENCTYPE="application/x-www-form-urlencoded">
<INPUT TYPE="hidden" name="canloadthirdframe" value="true">
<INPUT TYPE="hidden" name="datasourceloaded" value="">
<table>




            <TR>
                    
                    <TD BGCOLOR="#D3D3D3" >
                    
            <A NAME ="1" HREF="javascript: onSelect('TEBE4515','1','E','N');">
                <FONT SIZE=2 FACE="Geneva,Verdana,Tahoma,Arial,Helvetica,Sans-serif">
            Service Letter
            </font>
            </TD></TR>




</TABLE>
<input type=hidden name=Mediano value="">
<input type=hidden name=secno value="">
<input type=hidden name=state value="3">
<input type=hidden name=InfoTypeId value="16">
<input type=hidden name=Language value="">
<input type=hidden name=SectionSafetyIndicator value="">
</FORM>
<form name="form2" method="post"  action="/sisweb/sisweb/mediasearch/media_b.jsp" target="media_b" ENCTYPE="application/x-www-form-urlencoded">




<INPUT TYPE="hidden" name="canloadthirdframe" value="true">
<INPUT TYPE="hidden" name="boolDataSourceLoadedValue" value="">
<input type=hidden name=secno value = "" >
<input type=hidden name=loadflag value = "" >
</FORM>




<!-- WTR SRI - new form for new controller servlet -->
<FORM name="form3" method="post"  action="/sisweb/servlet/cat.dcs.sis.controller.sri.CSSISInfoAvailForSriServlet" target="media_c" ENCTYPE="application/x-www-form-urlencoded">
<INPUT TYPE="hidden" name="PsidSRI" value="">
<INPUT TYPE="hidden" name="SectionSystemSRI" value="">
<INPUT TYPE="hidden" name="command" value="sriSearchForInfoType">
<INPUT TYPE="hidden" name="fromPageForSri" value="media_b">
<INPUT TYPE="hidden" name="canloadthirdframe" value="true">
<INPUT TYPE="hidden" name="datasourceloaded" value="">




</FORM>
<form name="form4" method="post"  action="/sisweb/sisweb/mediasearch/media_b.jsp" target="media_b" ENCTYPE="application/x-www-form-urlencoded">
<INPUT TYPE="hidden" name="canloadthirdframe" value="true">
<INPUT TYPE="hidden" name="boolDataSourceLoadedValue" value="">




<input type=hidden name=psidSRI value = "" >
</FORM>












<SCRIPT LANGUAGE="javascript" SRC="/sisweb/sisweb/js/bookmark.js"></SCRIPT>
<SCRIPT LANGUAGE="javascript">
setBookmarkValue('https://sis.cat.com/sisweb/servlet/cat.dcs.sis.controller.integration.CSSISIntegrationServlet?accessmethod=media&lang=E&3framestate=N&smediano=TEBE4515&infotypeid=16&sectionno=1&levelseqno=i0&pippspno=PS45141');
</SCRIPT>
</BODY>
</HTML>

Display More

Yash20 · Jul 18th 2016

Re: Unable to click on a link from webpage

I tried to get all the elementstagname of ul and also another method to get all elementstagname of a, but no luck

Code

Set Doc = IE.Document




            Set Elements = Doc.getElementsByTagName("ul")




                For Each Element In Elements


                Next Element

Display More

Yash20 · Jul 17th 2016

I am trying to click on a Javascript <a> tag but unable to execute, Can anyone tell how to execute this using VBA code
Below is the source code.

HTML

<UL> <LI> <A NAME ="#TEBE45150001i0" HREF="javascript:onSelect('TEBE45150001','IETIT0','i0',0,'E');"> <FONT SIZE=2 FACE="Geneva,Verdana,Tahoma,Arial,Helvetica,Sans-serif" > PRODUCT SUPPORT PROGRAM FOR REPLACING NEEDLE VALVE SUPPLY TUBES ON CERTAIN G3606B, G3608B, AND G3612B PETROLEUM ENGINES 08/07/2016</font></A><P> </LI> </UL>