How can I Click on search button from VBA

June 29, 2015 at 09:07:40
Specs: Windows 7
How Can click on a search box of a webpage, picking up the data from excel; Example copy the data from Cell A3 Paste it in the search box of web page below is the HTML code
[Code]
<input type="text" name="_cb_Control_ctl00_ManagedCompaniesComboBox" id="_cb_Control_ctl00_ManagedCompaniesComboBox" _id="ctl00_ManagedCompaniesComboBox" value="Manage a company..." class="NormalMode" _w="Manage a company..." style="width: 260px;" _quickfilter="" _quickfiltertype="5" _s="True" _e="False" onclick="_cb_ClickIn(0, this, event);" onfocus="_cb_OnFocus(this);" onkeyup="return _cb_OnKeyDown(this, event);" onkeydown="return _cb_OnKeyDown(this, event, 1);">
[/Code]

Once the page is loaded click on a search button again. Below is the code for another search button

[Code]

<div id="ctl00_NavigationContainer" class="NavigationContainer">
<span id="NavMenuTop"></span><span id="NavMenuBottom"></span>
<div class="NavMenu">
<div id="AjaxProcessing" style="display: none;">
<img src="MtxResource.asmx?r=Images/Loading.gif">Data Loading...
</div>

<div class="NavItem">

<img src="MtxResource.asmx?r=Icons/Home.png" class="HomeIcon">Home

</div><div class="NavItemSeparator">|</div>
<div class="NavItem">

<img src="MtxResource.asmx?r=Icons/Search.png">Transaction Search

</div><div class="NavItemSeparator">|</div>
<div class="NavItem">

<img src="MtxResource.asmx?r=Icons/Chart.png">Reports

</div>
<div class="ClearLeft">
</div>
</div>
<div class="ClearBoth">
</div>
</div>

[/Code]


See More: How can I Click on search button from VBA

Report •


#1
November 17, 2015 at 11:12:08
I believe the newer versions of Microsoft Office have a feature just for that you can use. It's a button that allows you to program a wizard that does this very thing. What version of Office are you using?

Jonas "Jackal" Lear
http://www.sbccrew.com
Serving the South Bay Since 1999


Report •
Related Solutions


Ask Question