How to automate already opened Internet Explorer using excel macros
Vložit
- čas přidán 8. 09. 2024
- In this video we would learn:
How to connect to an already opened Internet explorer Window using excel macros
Pre-requisite: • How to Automate Web Sc...
Pre-requisites:
Man, I have no words to express my gratitude. I've been looking for so long for this solution... Thank you so much!!
Glad it helped!
You are truly Amazing !
You help me a lot from this video.
Thanks will be less to say you.
You are amazing human being
So nice of you
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
Glad it was helpful!
How do i do the same but in Chrome?
thank you very much this is what i was searching from a long time
your welcome
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.
video is very simple and informative but how can i activate the current IE and take screenshot of it? Thank You!
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?
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
Sir how to get date from google chrome and paste it in excel.
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.
shre ur code
Can we use same for google form
As in the last video which I saw it was working for text only.
yes it can be used.
Thank You, it works now :)
Great!
Can Anyone tell for the Edge
Hello! If the document.title is change after moving to another window, where can I indicate its name?
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
Hello sir, please share video on JMeter example of working on real-time project.
Thank you
You're welcome
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!
How can I help you?
For customized requirements please write into info@automationandagile.com
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.
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! =)
Refer below tutorials:
czcams.com/video/-GUw22ecRwI/video.html
czcams.com/video/g7xOwulfwK0/video.html
Can you do the same for edge browser
Like how can we automate already open edge browser through vba
Great!
Thanks
Welcome!
@@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?
i will need to see the page. You can try below alternate apporoach on edge
czcams.com/video/AEp0Yeis9AM/video.html
@@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]});}
"
Need VBA Help: How can we handle more than one ie windows in a program ? Can you please help?
you can use the same technique as explained in the tutorial. Search for title or url of the page and proceed further.
Sir - How to save/download opened windows in PDF format.
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
Refer below:
czcams.com/video/docnLSdj8rI/video.html
@@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
@@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.
need to see the web page
@@AutomationMadeEasy How can I contact you? Through email?
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! =)
can u paste the script
@@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 ExistingBrowserCZcams()
On Error Resume Next
Set objShell = CreateObject("Shell.Application")
MsgBox objShell.Windows.Count
End Sub
On the VBA editor got to Tool/References -
On the References select Microsoft Shell Controls And Automation
Click OK
Then re -execute
After auto filled, if we click on any fields the values are getting cleared automatically.. can u tel me y?? How to stop this
Is there any way in which data entry can done in alredy opened chrome browser? Pls reply
unfortunately no
@@AutomationMadeEasy thank you for your reply... I just finished a work using automate in chrome
@@AutomationMadeEasy can i use python for that purpose?? Will it work?
Can we fill data in web page with given set of conditions such as any particular text or number displayed in web page?
Absolutely yes
@@AutomationMadeEasy Please upload a video on this.
its not ageneric solution, changes from page to page. For customized solutions/training write into info@automationandagile.com
Its counting opened file explorer windows not edge what should i do
It is showing IE = Empty after setting break and executing on Set IE = objshell.Windows(intWinNo).document.
Please help
did u writ On error Resume next ?
Sir please explain this thing on chrome browser in a new video...i will be very thankful to you
So for chrome we can't use all ready opened taps?
nopes
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
Did you try on edge/chrome?
i amunable to do this properly...please help...thanks
my email christianrsud@gmail.com
Hi i want Enter Excel values To a web Page Already opened For Data Entry on chrome
not feasible
How to open web link using macro pls help urgently
Can this be done using URL instead of title
yes. it is explained
Web page title show in hindi font how write in vba
Sir please help me
try with url. it is explained in the tutorial
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 🙏
its not a web application so seems not feasible
@@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 🙏
all users must be on the same network as the database.
@@AutomationMadeEasy no , they are in different locations!!
Anyway thank you so much 🙏I'm grateful to you ⚘
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 🙏
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
This solution works only on Internet Explorer
Sir can you please write the same code using Option Explicit?
you have to just decalre the variables used with option explicit
@@AutomationMadeEasy got it, I had add some typo error not it fixed. Thank you for replying.
In Firefox Browser how to do ?
FF not feasible. For edge refer below tutorial:
czcams.com/video/AEp0Yeis9AM/video.html
What if the Page title contains Hindi Letters
use the same technique using url
@@AutomationMadeEasy yes thank you
no function :(