How to automate already opened Internet Explorer using excel macros

In this video we would learn:
How to connect to an already opened Internet explorer Window using excel macros

Pre-requisites:

[AdautoAraujo]

Man, I have no words to express my gratitude. I've been looking for so long for this solution... Thank you so much!!

[prasenjitmandal]

You are truly Amazing !
You help me a lot from this video.

Thanks will be less to say you.
You are amazing human being

[J-oker]

What a fantastic tutorial, I only know basic excel, but I really feel with this tutorial I will be able to preform an advanced solution to my problem

[cenationrko]

thank you very much this is what i was searching from a long time

[rodrigoordenes]

Hello, I need to ask you a question. How to send a tab or enter to the web page being controlled with IE VBA. Thank you.

[dannygrio]

does internet explorer still exist or can you do the same with edge? I am looking for something like this, as I have to login in the page with a form available (database online). Therefore, I was looking for something like this, but for edge, chrome etc. I cant get explorer anymore I suppose.

[rcbhk]

Nice work.. great skills!!! i will be thankful if you can explain the way we can run the macro from webpage ? like we enter the value for name on webpage and rest of the details are automatically fetched from excel into this form?

[sagarbhai]

video is very simple and informative but how can i activate the current IE and take screenshot of it? Thank You!

[zloyserver]

Hello! If the document.title is change after moving to another window, where can I indicate its name?

[lalitshete]

Can we use same for google form
As in the last video which I saw it was working for text only.

[lf]

HELP! I've written and tested my code for a single row but "It either Hangs or doesn't run at all" when I use a for loop for entering data and fetching it to and from excel Sheets.

[MrScratchOdia]

Is there any way in which data entry can done in alredy opened chrome browser? Pls reply

[shubhamchouhan]

Sir how to get date from google chrome and paste it in excel.

[KM-comx]

Dear Sir, where can we find all the Excel VBA commands to controlling the Mouse & Keyboard? I enjoying learning from your video's.
Lets say, I wrote,

= "qwerty"

Then,
How do I send a return carriage r enter?
How do I sent a left click, etc?
I can't find what the list is in VBA

Thank you so much! =)

[Leslei]

Hello! Your macro works perfectly, but im trying to adapt it to our ERP (JD Edwards) which uses explorer also and im not able to make it work. It does find the webpage, but it just doesnt fill the information. Your help would be very appreciated. Thank you!

[amol]

Can you do the same for edge browser
Like how can we automate already open edge browser through vba

[KM-comx]

Thank you for this wonderful video. I've followed along but I get an compile error for the line "Set objShell = stating Variable not Defined. How did you get around this? I tried defining it to Application, Windows, etc but then my objShell.Windows.Count result was always zero. So I must be defining it incorrectly. Please advise and thank you in advance! =)

[ksathiya]

Thanks for the video helped me a lot. I just need one help, is it possible to scrap details using this same condition. I tried combination of multiple, but it was not working properly. It is working until to enter specific value in website, but unble to scrap specific details. Pls help me

[mkv]

Hello, I have seen tutorials it is very informative and very easy to understand.
I have doubt in clicking a check box in a website using EXCEL VBA
the check box values will be dynamic.It seems to be very challenging for me. If someone helps me to fix this i will feel awesome.
I have mentioned below the HTML elements for your reference.


Excel Input Range(A1)= (2015, 2018) Excel Input Range(B1)= (KD)
Excel Input Range(A2)= (2015) Excel Input Range(B2)= (KD)
Excel Input Range(A3)= (2015) Excel Input Range(B3)= (blank)



Scenario :1 Del Qualifier Type Qualifier Code
CbeckBox(0) MY 2018
CbeckBox(1) MY 2017
CbeckBox(2) MY 2016
CbeckBox(3) MY 2015
CbeckBox(4) VT L
CbeckBox(5) VL KD
CbeckBox(6) VL K#
Scenario :2 Del Qualifier Type Qualifier Code
CbeckBox(0) MY 2017
CbeckBox(1) MY 2016
CbeckBox(2) MY 2015
CbeckBox(3) VT L
CbeckBox(4) VL KD
CbeckBox(5) VL K#
Scenario :3 Del Qualifier Type Qualifier Code
CbeckBox(0) MY 2016
CbeckBox(1) MY 2015
CbeckBox(2) VT L
CbeckBox(3) VL K#



From the above three scenario I want to select qualifer code (2015, 2018 & KD)
Note: Scenario :3 is not having Qualifer Code - 2018 & KD.


So in these how we can select the check boxes.

For your easy reference
<input type="checkbox" name="chkDel" value="0|MY|2018~"></td>
<input type="checkbox" name="chkDel" value="1|MY|2017~"></td>
<input type="checkbox" name="chkDel" value="2|MY|2016~"></td>
<input type="checkbox" name="chkDel" value="3|MY|2015~"></td>
<input type="checkbox" name="chkDel" value="4|VT|L~"></td>
<input type="checkbox" name="chkDel" value="5|VL|KD~"></td>
<input type="checkbox" name="chkDel" value="6|VL|K#~"></td>



<tbody><tr
<th>&nbsp;</th>
<th class="center">Del</th>
<th class="center">Qualifier Type</th>
<th class="center">Qualifier Code </th>
<th class="center">Abbreviation </th>
<th class="center">Print </th>
<th class="center">Rev </th>
<th class="center">User Id </th>
<th class="center">Date </th></tr>

<!-- Printing -->
<!-- QT="MY" QC="2018" -->
<!-- UpdateId:VKUMARAG -->
<input type="hidden" name="QualifierType0" value="MY">
<input type="hidden" name="QualifierCode0" value="2018">
<input type="hidden" name="Print0" value="Y">
<tr id="tr0"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(0)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="0|MY|2018~"></td>
<td class="center">&nbsp;
MY</td>
<td
<td class="left">&nbsp;
Eff: Ineff: </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>

<!-- Printing -->
<!-- QT="MY" QC="2017" -->
<!-- UpdateId:VKUMARAG -->
<input type="hidden" name="QualifierType1" value="MY">
<input type="hidden" name="QualifierCode1" value="2017">
<input type="hidden" name="Print1" value="Y">
<tr id="tr1"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(1)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="1|MY|2017~"></td>
<td class="center">&nbsp;
MY</td>
<td
<td class="left">&nbsp;
Eff: Ineff: </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td

</tr>

<!-- Printing -->
<!-- QT="MY" QC="2016" -->
<!-- UpdateId:ACYRUS3 -->
<input type="hidden" name="QualifierType2" value="MY">
<input type="hidden" name="QualifierCode2" value="2016">
<input type="hidden" name="Print2" value="Y">
<tr id="tr2"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(2)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="2|MY|2016~"></td>
<td class="center">&nbsp;
MY</td>
<td
<td class="left">&nbsp;
Eff: Ineff: </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>

<!-- Printing -->
<!-- QT="MY" QC="2015" -->
<!-- UpdateId:APIMPORT -->
<input type="hidden" name="QualifierType3" value="MY">
<input type="hidden" name="QualifierCode3" value="2015">
<input type="hidden" name="Print3" value="Y">
<tr id="tr3"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(3)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="3|MY|2015~"></td>
<td class="center">&nbsp;
MY</td>
<td
<td class="left">&nbsp;
Eff: Ineff: </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>
<!-- Printing -->
<!-- QT="VT" QC="L" -->
<!-- UpdateId:APIMPORT -->
<input type="hidden" name="QualifierType4" value="VT">
<input type="hidden" name="QualifierCode4" value="L">
<input type="hidden" name="Print4" value="Y">
<tr id="tr4"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(4)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="4|VT|L~"></td>
<td class="center">&nbsp;
VT</td>
<td class="center">&nbsp;
L</td>
<td class="left">&nbsp;
Truck </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>
<!-- Printing -->
<!-- QT="VL" QC="KD" -->
<!-- UpdateId:VKUMARAG -->
<input type="hidden" name="QualifierType5" value="VL">
<input type="hidden" name="QualifierCode5" value="KD">
<input type="hidden" name="Print5" value="Y">
<tr id="tr5"><td width="1"> <input type="radio" name="rdOperation" onclick="return radio_onclick(5)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="5|VL|KD~"></td>
<td class="center">&nbsp;
VL</td>
<td class="center">&nbsp;
KD</td>
<td class="left">&nbsp;
RANGER ICA </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>
<input type="hidden" name="QualifierType6" value="VL">
<input type="hidden" name="QualifierCode6" value="K#">
<input type="hidden" name="Print6" value="Y">
<tr id="tr6"><td width="1"> <input type="radio" name="rdOperation" language="javascript" onclick="return radio_onclick(6)"> </td>
<td width="1">
<input type="checkbox" name="chkDel" value="6|VL|K#~"></td>
<td class="center">&nbsp;
VL</td>
<td class="center">&nbsp;
K#</td>
<td class="left">&nbsp;
RANGER OLD </td>
<td class="center">&nbsp;
Y</td>
<td class="center">&nbsp;
A</td>
<td
<td
</tr>

</tbody>

[MrExcel-iflc]

After auto filled, if we click on any fields the values are getting cleared automatically.. can u tel me y?? How to stop this