excel to web/ web scraping

[oodai]

The process that i do is very manual and repeating same kind of steps every day
Below is the detailed steps. Please help me with vba to automate this
Step 1 Copy the Banner Number from excel (Cell P3)
Step 2 Click on Search button in webpage
Step 3 Copy the store Number from excel
Click on search button (O3)
Step 4 Pick date from excel and paste in webpage (Cell G3)
Step 5 Update account and paste it in account (Cell I3 right 4 digits)

Select Each link in the page
Step 7 Once the page is opened take screen print of the page and save to a folder
[TABLE="width: 109%"]
<tbody>[TR]
[TD]Input
[/TD]
[TD]Html code
[/TD]
[/TR]
[TR]
[TD]Copy the company Number from excel (Cell A2)
[/TD]
[TD]<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" *******="_cb_ClickIn(0, this, event);" onfocus="_cb_OnFocus(this);" onkeyup="return _cb_OnKeyDown(this, event);" onkeydown="return _cb_OnKeyDown(this, event, 1);">

[/TD]
[/TR]
[TR]
[TD]Click on Search button in webpage
[/TD]
[TD]<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">
<a href="../Default.aspx">
<img src="MtxResource.asmx?r=Icons/Home.png" class="HomeIcon">Home</a>
</div><div class="NavItemSeparator">|</div>
<div class="NavItem">
<a href="TransactionSearch.aspx">
<img src="MtxResource.asmx?r=Icons/Search.png">Transaction Search</a>
</div><div class="NavItemSeparator">|</div>
<div class="NavItem">
<a href="../Reports/Reports.aspx">
<img src="MtxResource.asmx?r=Icons/Chart.png">Reports</a>
</div>
<div class="ClearLeft">
</div>
</div>
<div class="ClearBoth">
</div>
</div>

[/TD]
[/TR]
[TR]
[TD]Copy the store Number from excel
Click on search button (O3)
[/TD]
[TD]<input type="text" name="_cb_Control_ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_StoresComboBox" id="_cb_Control_ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_StoresComboBox" _id="ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_StoresComboBox" value="Select a Store..." class="NormalMode" _w="Select a Store..." style="width: 200px;" _quickfilter="" _quickfiltertype="5" _s="True" _e="False" *******="_cb_ClickIn(0, this, event);" onfocus="_cb_OnFocus(this);" onkeyup="return _cb_OnKeyDown(this, event);" onkeydown="return _cb_OnKeyDown(this, event, 1);">

[/TD]
[/TR]
[TR]
[TD]Pick date from excel and paste in webpage (Cell G3)
[/TD]
[TD]<input name="ctl00$MainContent$SearchWizard$SearchCriteriaStep$SearchCriteria$SearchDates_TextBox" type="text" id="ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_SearchDates_TextBox" style="margin-bottom:5px;" class="Watermark">

[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Update account and paste it in account (Cell I3 right 4 digits)
[/TD]
[TD]<input name="ctl00$MainContent$SearchWizard$SearchCriteriaStep$SearchCriteria$AccountLast4TextBox" type="text" id="ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_AccountLast4TextBox" style="width:38px;" class="Watermark">

[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]<input type="submit" name="ctl00$MainContent$SearchWizard$SearchCriteriaStep$SearchCriteria$SearchTransactionsButton" value="Search" *******="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$MainContent$SearchWizard$SearchCriteriaStep$SearchCriteria$SearchTransactionsButton", "", true, "", "", false, false))" id="ctl00_MainContent_SearchWizard_SearchCriteriaStep_SearchCriteria_SearchTransactionsButton">

[/TD]
[/TR]
[TR]
[TD]Select Each link in the page
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Once the page is opened take screen print of the page and save to a folder
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rijnsent]

Hi Oodai,

and what code have you come up with so far?

Koen