How to automate already opened Internet Explorer using excel macros

[@AdautoAraujo]

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

[@AutomationMadeEasy]

Glad it helped!

[@prasenjitmandal5486]

You are truly Amazing ! You help me a lot from this video. Thanks will be less to say you. You are amazing human being

[@AutomationMadeEasy]

So nice of you

[@J-oker251]

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

[@AutomationMadeEasy]

Glad it was helpful!

[@cenationrko4445]

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

[@AutomationMadeEasy]

your welcome

[@Dani-kk7fe]

How do i do the same but in Chrome?

[@rodrigoordenes4858]

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.

[@adrianb6193]

Thank You, it works now :)

[@AutomationMadeEasy]

Great!

[@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?

[@AutomationMadeEasy]

thanks. executing macro from web page is not feasible but you can use the approach explained in this tutorial to enter a the value manually on the already opened web page and then execute the excel macro

[@sagarbhai6638]

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

[@rpfoodie799]

Can Anyone tell for the Edge

[@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.

[@lf7801]

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.

[@AutomationMadeEasy]

shre ur code

[@zloyserver4438]

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

[@lalitshete5219]

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

[@AutomationMadeEasy]

yes it can be used.

[@shubhamchouhan295]

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

[@geekysantosh]

Hello sir, please share video on JMeter example of working on real-time project.

[@danielepicchianti1877]

Great! Thanks

[@AutomationMadeEasy]

Welcome!

[@danielepicchianti1877]

@@AutomationMadeEasy Hello my friend, on a web page I need to select an item from the drop-down list. Also I need to select a check box and finally click on the submit button. Could you help me with a Vba code?

[@AutomationMadeEasy]

i will need to see the page. You can try below alternate apporoach on edge kzbin.info/www/bejne/d3bTYYybnthsd68

[@danielepicchianti1877]

@@AutomationMadeEasy Hello, this is the html code for the drop down list: "" and the Check-box code: " Aliquota IVA Natura IVA rcAbilitaAliquotaIva = function() {PrimeFaces.ab({formId:'f2',source:'j_idt371',process:'@all',update:'inputAliquotaIva cmbNaturaIva',params:arguments[0]});} rcAbilitaNaturaIva = function() {PrimeFaces.ab({formId:'f2',source:'j_idt372',process:'@all',update:'inputAliquotaIva cmbNaturaIva',params:arguments[0]});} "

[@Leslei8417]

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!

[@AutomationMadeEasy]

How can I help you? For customized requirements please write into [e-mail]

[@kamalakotagiri7174]

Need VBA Help: How can we handle more than one ie windows in a program ? Can you please help?

[@AutomationMadeEasy]

you can use the same technique as explained in the tutorial. Search for title or url of the page and proceed further.

[@amol3070]

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

[@MrScratchOdia]

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

[@AutomationMadeEasy]

unfortunately no

[@MrScratchOdia]

@@AutomationMadeEasy thank you for your reply... I just finished a work using automate in chrome

[@MrScratchOdia]

@@AutomationMadeEasy can i use python for that purpose?? Will it work?

[@hejeebuprasad]

Thank you

[@AutomationMadeEasy]

You're welcome

[@KM-co5mx]

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, IE.getElementsByName("q")(0).Value = "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! =)

[@AutomationMadeEasy]

Refer below tutorials: kzbin.info/www/bejne/Y3i4qGVomsiFras kzbin.info/www/bejne/nWjbgKqrocuqgZI

[@MultiDirection]

Can we fill data in web page with given set of conditions such as any particular text or number displayed in web page?

[@AutomationMadeEasy]

Absolutely yes

[@MultiDirection]

@@AutomationMadeEasy Please upload a video on this.

[@AutomationMadeEasy]

its not ageneric solution, changes from page to page. For customized solutions/training write into [e-mail]

[@ksathiya4576]

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

[@AutomationMadeEasy]

Refer below: kzbin.info/www/bejne/mqDGn3-Jmc9rqKs

[@ksathiya4576]

@@AutomationMadeEasy Thanks for your reply. I watched both videos and tried to combine both but it is not working for me. Below the details what I entered. Sub Test() On Error Resume Next Set objShell = CreateObject("Shell.Application") intWinCnt = objShell.Windows.Count For intWinNo = 0 To (intWinCnt - 1) strWinTitle = objShell.Windows(intWinNo).document.Title If strWinTitle = "Order Inquiry" Then Set IE = objShell.Windows(intWinNo).document Exit For End If Next IE.getElementsByName("ctl00$cntMain$txtOrderNumberId")(0).Value = "123456" IE.getElementById("cntMain_rdOrderNumber").Click IE.getElementById("btnOk").Click *****Until Here its working perfect****** strPoTl = doc.getElementById("cntMain_txtTotalCost").innerText strPoOs = doc.getElementById("cntMain_txtOutLandCost").innerText ThisWorkbook.Sheets("Sheet2").Range("B2").Value = strPoTl ThisWorkbook.Sheets("Sheet2").Range("C2").Value = strPoOs

[@ksathiya4576]

@@AutomationMadeEasy I don't know where I'm making mistake. While running I'm not getting any error, but also not getting the details what I needed. So Pls help me.

[@AutomationMadeEasy]

need to see the web page

[@ksathiya4576]

@@AutomationMadeEasy How can I contact you? Through email?

[@KM-co5mx]

Thank you for this wonderful video. I've followed along but I get an compile error for the line "Set objShell = CreateObject("Shell.Application")" 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! =)

[@AutomationMadeEasy]

can u paste the script

[@KM-co5mx]

@@AutomationMadeEasy Thank You in Advance!... Here's what I have. I wrote it exactly as I saw in the video... I get a compile error on objShell, Variable not defined. I'm running VBA 7.1.1110, Excel 2016 Sub ExistingBrowserKZbin() On Error Resume Next Set objShell = CreateObject("Shell.Application") MsgBox objShell.Windows.Count End Sub

[@AutomationMadeEasy]

On the VBA editor got to Tool/References - On the References select Microsoft Shell Controls And Automation Click OK Then re -execute

[@ibrahimriyadhalrikabi757]

Hi dear , I've question if possible: I need strongly to share my VBA project with many users the same time on internet (at least 20 users) Please advise me 🙏

[@AutomationMadeEasy]

its not a web application so seems not feasible

[@ibrahimriyadhalrikabi757]

@@AutomationMadeEasy If possible to answer this one too: I have 20 users using my vba project, and I have database, So I want them to check if there is a replacement in that database .. how to do that?!! Except spreadsheet because it is not safe.. can you advise me how to solve this problem? Please 🙏

[@AutomationMadeEasy]

all users must be on the same network as the database.

[@ibrahimriyadhalrikabi757]

@@AutomationMadeEasy no , they are in different locations!! Anyway thank you so much 🙏I'm grateful to you ⚘

[@ibrahimriyadhalrikabi757]

Hi bro, i solved it 💪 I downloaded drive application in each user's Laptop and put the same account in ,and when someone makes changes on VBA project on his laptop.. these changes updates automatically on the others laptops 😉💪💪💪💪 Might its easy and very useful way could help you . Thank you for your reply brother 🙏

[@MrExcel-if7lc]

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

[@diljaipuria6393]

Sir when I use coding for pmfby website it's name in tab not simple like form but it's contain special characters that's why it not working

[@AutomationMadeEasy]

Did you try on edge/chrome?

[@mohanraju9743]

Sir - How to save/download opened windows in PDF format.

[@balajiprasath3895]

So for chrome we can't use all ready opened taps?

[@AutomationMadeEasy]

nopes

[@mkv7595]

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   Del Qualifier Type Qualifier Code Abbreviation Print Rev User Id Date   MY   2018   Eff: Ineff:   Y   A   VKUMARAG   06-mar-2018   MY   2017   Eff: Ineff:   Y   A   VKUMARAG   27-may-2016   MY   2016   Eff: Ineff:   Y   A   ACYRUS3   17-nov-2015   MY   2015   Eff: Ineff:   Y   A   APIMPORT   20-sep-2013   VT   L   Truck   Y   A   APIMPORT   20-sep-2013   VL   KD   RANGER ICA   Y   A   VKUMARAG   23-apr-2020   VL   K#   RANGER OLD   Y   A   APIMPORT   20-sep-2013

[@rightclick9408]

Can this be done using URL instead of title

[@AutomationMadeEasy]

yes. it is explained

[@navingupta3697]

It is showing IE = Empty after setting break and executing on Set IE = objshell.Windows(intWinNo).document. Please help

[@AutomationMadeEasy]

did u writ On error Resume next ?

[@KumarAnalytic]

Sir can you please write the same code using Option Explicit?

[@AutomationMadeEasy]

you have to just decalre the variables used with option explicit

[@KumarAnalytic]

@@AutomationMadeEasy got it, I had add some typo error not it fixed. Thank you for replying.

[@kartikeysingh7159]

Its counting opened file explorer windows not edge what should i do

[@AbdulSalam-vi7gt]

How to open web link using macro pls help urgently

[@kristiankonstantinus4968]

i amunable to do this properly...please help...thanks

[@kristiankonstantinus4968]

my email [e-mail]

[@dineshup669]

Hi i want Enter Excel values To a web Page Already opened For Data Entry on chrome

[@AutomationMadeEasy]

not feasible

[@khilavanchakradhari1112]

Web page title show in hindi font how write in vba Sir please help me

[@AutomationMadeEasy]

try with url. it is explained in the tutorial

[@TN--S]

In Firefox Browser how to do ?

[@AutomationMadeEasy]

FF not feasible. For edge refer below tutorial: kzbin.info/www/bejne/d3bTYYybnthsd68

[@Khalnayak_sanju143]

Sir how use this code for chrome and how to defined intWInNo for excel vba my Excel showing error for intWInNo and IE variable not defined Please help me to solve this problem

[@AutomationMadeEasy]

This solution works only on Internet Explorer

[@kamransiddiqui4879]

Sir please explain this thing on chrome browser in a new video...i will be very thankful to you

[@areamanager2355]

What if the Page title contains Hindi Letters

[@AutomationMadeEasy]

use the same technique using url

[@areamanager2355]

@@AutomationMadeEasy yes thank you

[@sqrAnton]

no function :(