Excel - IE Automation

[Macrosian]

I need to open a website (Auto login by IP address detection) and then click a link (search) for going to search page.

I cannot directly go to the hyperlink as it will be declined by website as session expired. First i need to open the home page then it will be auto login by browser the I can move forward


</span><span>|</span> <span>
<a href="Forms/Company/SearchCompany.aspx?PageName=Default">Search</a></span>
</div>

On the next page I need to enter some values and click search button,

Text Box code

<td class="LabelCell"> <span id="ctl00_PageBody_SearchCompany1_lbDCompanyName"
class="editBox" style="display:inline-block;border-style:Solid;width:200px;">Company Name (ENG)</span> </td>
<td class="SepCell">| </td> <td class="ReadCell"> <input name="ctl00$PageBody$SearchCompany1$txtCompanyNameEn"
type="text" maxlength="100" id="ctl00_PageBody_SearchCompany1_txtCompanyNameEn"
class="editBox" style="border-style:Solid;width:200px;text-align: left;" /> </td> <td class="SepCell">| </td> <td class="LabelCell">

Then click this button..



<input type="submit" name="ctl00$PageBody$SearchCompany1$btnSearch" value="Search &amp; Modify"
onclick="javascript:WebForm_DoPostBackWithOptions(new
WebForm_PostBackOptions(&quot;ctl00$PageBody$SearchCompany1$btnSearch&quot;,
&quot;&quot;, true, &quot;checkNum&quot;, &quot;&quot;, false, false))"
id="ctl00_PageBody_SearchCompany1_btnSearch" class="actButton"
style="width:120px;" />
<input type="submit" name="ctl00$PageBody$SearchCompany1$btnClear" value="Clear" onclick="return ClearParameters();"
id="ctl00_PageBody_SearchCompany1_btnClear" class="actButton" style="width:84px;" />
<input type="submit" name="ctl00$PageBody$SearchCompany1$btnClose" value="Close" id="ctl00_PageBody_SearchCompany1_btnClose" class="actButton" style="width:84px;" />


Please advice the steps..