thanks a bunch. I still have to build the macro I need, but this was really useful and very well explained. 👍 I've kept a shortcut to your video so that I can share it with some friends who would be interested in doing edge automation too. I'll ask them to give a thumbs up when they come. bye, and thanks again. 🙂
I had to change the Year field name from "day" to "year" in the HTML code to be able change the year value. If I were the only one to have this problem, there is something I am missing. But thanks for the info. It really helped me.
I haven't done Excel VBA programing since 2008. Could not find a job doing it, since no formal training. Learned on my own by reading help files. Your videos are filling in the details where I missed earlier in my attempts. I did send automated emails, but didn't use the Outlook library at the time. It was Excel 5.0, so couldn't do it with newer Excel versions.
Great Tutorial Thank you, Sir .. very clear instruction .. but when I have tried to navigate to an already logged-in site I need to log in again & again each time.. so how to navigate a site without the need to re-login...
Dot net 3.5 might be missing. Search for Features on windows serach bar on the bottom of the desktop. Select Turn windows featurs on or off. Select dot net 3.5. Install it. Close all your excel workbooks.Open the workbook in which tou have written the script and execute.
Thanks. Dot net framework 3.5 might be missing Close of Excel workbooks Click on Start Windows icon Search for features Click on Turn Windows features on or off On the next window select dot net framework 3.5 Download and install Now retry
TL;DR: If you follow the steps in the video, and you get "Automation Error" when running your code, you might need to install .Net Framework 3.5, even if you have a later version. Thank you for doing such a thorough video. I am having a problem, though. When I run this code Dim WD As New WebDriver WD.Start "edge", "" On the WD.start line, I get: Automation Error. Previously, I had: Dim WD As New WebDriver Set WD = New WebDriver and the Set line also returned: Automation Error. My Edge version is 90.0.818.66. I copied the MSEdgeDriver into the selenium folder (and renamed it). Where should I look to troubleshoot this? I was just thinking: I used the x64 version. Do I absolutely need the x86? Tried it. That wasn't it. Turns out I needed to install .Net Framework 3.5 (despite already having .Net Framework 4.8). I discovered this when I tried to run C:\Users\Username\AppData\Local\SeleniumBasic\Scripts\StartEdge.vbs
Thank u for this very informative video. Is it possible to open multiple chrome profiles at once and use the script to fill out forms on those profiles? Thank uu
This is what I was looking for, just a quick question. If I wrote some code for web scrapping and someone else want to run it on their system do they have to install Selenium on their system as well?
Might get an AI interpreter job. Plan to do voice to text, then go to the website. I presume that I will need the speech to text library downloaded or checked.
Thanks for the clear video, my VBA test code works. I'm just wondering if we now have to download the web driver again, rename it and put it in the correct folder with every update of edge?
Thank u for the video, i have a challenge and need help, Start and Get open a new instance of edge, how i can assign an already opened instance of edge to an object. My web page is already opened and i want to parse data, using Get and Start will reopen the page, is there a way to assign current open page to the object.?
Thank You. Can you please show how to navigate to another browser window and perform some actions on it using excel macro? How to handle multiple browser windows?
Hi, this is an excellent tutorial. I was wondering if you could help with an alternative to "Selenium Basic"? I am afraid my organization's IT department may not approve it. Is there an Excel Add-in?
Hello brother, great video it helped. By the way, now that we have built this macro, how do we send data from excel columns to the website? Do you have a separate video for that? P.S. I am a complete begineer.
Thank you very much for all your videos and I been learning a lot with all of them. This is almost my Netflix if you know what I mean. Can I use this on a page where I have to login to my account and then find the form?
@@AutomationMadeEasy thank you for quick reply! If the page has a login, then a user page with a form, do I follow this tutorial the same way. Meaning I add the URL, but when it asks for a login, what do I do? Thanks again and great job!!
Need help, If the browser version gets updated in the system, We have to update the same in Selenium Basic, Is it possible to get auto-updated in selenium basic
Using the video I could write the code(using edge and leaving IE) for logging into this site(identifier, password, etc..), In my former "IE written" code I used a handle to do several things on this site: Is it always possible to get such a handle, or should I code in a different way?
Great Video. I tried implementing it the bowser opens and navigates to the URL provided but it closes automatically in like 5-6 seconds is there any solution for this issue?
great one... thank you.... is there any possibility of doing this (autoamting edge tasks) without selenium? Also, wondering if I use selenium and create a macro and want to share it with other people, do they need to have selenium installed in their system for this macro to work?... thanks in advance
Thank You !! But I just want to know is there any way to make connection with EDGE using VBA only without installing any additional software. Please do the needful.
well dates have different formats both on excel and web pages. It all depends how the web page expects it, so there isnt any generic solution. Custom code would be needed as per the design aof the web page.
Thanks for your video I am having one more doubt we need to achieve this autimation we have to install each every user for selinium basic application then only this can be achieved or is there any another option without installation for selinium basic for all the user we can automate or not thanks in advance.Can you application
Thanks for these wonderful videos on web automation using vba. I was looking for VBA automation for downloading JSON object which is parsed from a different url. So, if we check the link in edge json object text appears. But in ie a pop up appears asking to save the object. Do not know how to automate and download this object using vba. Any suggestion? Unable to share the url/link due to security reasons. Thank you again for these amazing videos. this is Great Learning
So if I am building this macro enabled spreadsheet to utilize this process with filling in edge forms and each person's computer has a different version of edge, will this work? If not, how can I make a version that can be shared with others with different version of edge? If there isn't, there has got to be a reliable way to doing this for people that share the same process.
your video was very helpful to me thank you, but i need to update data from excel(more then 2 line) to web portal and submit with ok popup button, please guide
Great video! It's a very clear guide. While I have the following problem: Run-time error'-2146233078(80131150a)': The source was not found, but some or all event ligs could not be searched. Inaccesible logs:Security. bug line: obj.Start "edge", ""
hello, its there any option that does not require installing selenium basic since i planned to share the program to other clients that are not familiar with stuff like software installation.
browser will close after the last line of code is executed by default. If you want browser to remain open but a message box at the end . The browser wont close until the message box is dismissed. Syntax given below: MsgBox "Wait"
Thanks for your video, it's very helpful. I have a problem in first syntax. It always appearing "run-time error '-2146232576 (80131700)': Automation Error". If I click on debug, the line "obj.Start "edge", "" " highlighted. I assumed there is a problem in my edge, but when I tried your tutorial for chrome, the same problem occured again. Any suggestion?
dot net framework 3.5 must be missing. Install using below steps. 1. Type 'Features'in Windows search box 2. Select Turn Windows Featurs on and Off'' 3. First option would be dot net 3.5 4. Select that option 5. Click ok to download 6. It will take a while to have the downloaded completed 7. After download completes restart your system 8. Now execute your macro
@@AutomationMadeEasy I've had the same problem. Unfortunately, it's still not working out even after installing framework 3.5! Maybe because I work in a company which I don't have administrator permission to do some IT operations due to security policy. Even so I could install it without any error except this one I mentioned. I also changed the edgedriver.exe to both version, 64 and 86, no change! Does someone know what it's going on? I have no idea!
@@AutomationMadeEasy did follow the steps but getting other error after . It always appearing "run-time error '-21: Timeout Error". The driver failed to opn the listening port 127.0.0. 1:49899 . If I click on debug, the line "obj.Start "edge", "" " highlighted.
when I ran the macro, the Edge closed by itself immediately after being loaded. do not know why? it also showed an info bar on top "Microsoft Edge is being controlled by automated test", any suggestion to fix the issues? thanks
thats default behaviour browser will close after last line of code gets executed. if you want to keep browser open keep the Dim obj as New Webdriver out side of Sub as given below Dim obj As New WebDriver Sub test12() 'Your code End Sub
I cant force my users to use Internet Explorer or Edge. Assuming the user selects their browser from a drop-down menu, is there any way to automatically fill in the web form if its in Chrome, Firefow or Opera browser instead?
@@AutomationMadeEasywill my clients need to have selenium installed to run the macro? I don’t think I can expect them to do that. Can it work without them doing downloading anything special?
its like any other software. Minimum one installation would be needed.Other solutions may be feasible but for that I need to see the web page to assess.
Unfortunately, I receive an automation error on the line " obj.Start "edge", "" ". The same happens with Chrome. Do you know what might be causing an issue? My version of Edge is "123.0.2420.81 (Official build) (64-bit)" and I have up to date web driver for it.. Thank you in advance!
Hi, I logged in successfully in a wedsite, but once the code finished the run time the edge browser is closing. I want it to stay visible. Please help. But great tutorial. Thank you.
Hi, how do I insert date in web form , in the web form when I manually click it opens a calendar, I have date in excel how do I get in form , please help
thats by default if you want the browser to remain open. Put Dim obj As New WebDriver on top of begining of sub. Example given below: Dim obj As New WebDriver Sub test1() '====== End sub
I followed all the steps and downloaded the edge driver, and when executing the code, an error is given when this code reads: "obj.Start "edge"," "Please, what should I do?"
good afternoon, I followed all the steps and managed to start. So that as soon as you open the site, it automatically disappears / closes. What will be the problem? greetings
assuming sheetname is Sheet1 var strname = ThisWorkbook.Sheets("Sheet1").Range("B3").text obj.findElementbyId("id of element").sendKeys(strname) You will have to use senkeys but value ypu can store in a variable.
Print Thanks bro for response but have a problem run time error 7 No such element error Element not found for Xpath=//*[text()='print'] Purpose :print form save as PDF My previous method It filled all forms then I give 5 sec pause (code done) Application. Send keys "^{p}" it opens print Then I gave few sec again Then I Application. Sendkeys"^{enter or~ } It not perform enter Even I used your tab Key techniques till print then send enter that also not work Later I seen print in webpage therefore I inspect, rest you know above element is print tabs Class
I am unable to find my edge driver version in the downloads and was not able to access the website which navigated it was being forced to close when I run the program
Hi. I am trying to figure out a way to get to the element that is in a DIV but there are two on the page. The only thing different is the text in the tag: Cancel - then in the second one instead of cancel it says Refund. I always need the 2nd one. I cannot figure out a way to find it. BTW: your videos are great! I have watched many. Thank you
try this obj.findElementByXpath("//*[@class='continueBtn btn btn-danger']").click If it does not work share url of the web page I will help you correctly identify it.
When trying to open edge Brower using the technique.. I get a message and edge closes immediately . "Microsoft Edge is being controlled by automated test software" Win 10 64 bit. | Edge Version 96.0.1054.34 (Official build) (64-bit)
@@AutomationMadeEasy True. Apologies I should have mentioned that in my case it was first line within the sub that closed the browser.. But anyways now it is fixed, a computer restart did the trick. Thank you for trying and the helpful video.
@@AutomationMadeEasy Thanks bro for response but have a problem run time error 7 No such element error Element not found for Xpath=//*[text()='print'] Purpose :print form save as PDF My previous method It filled all forms then I give 5 sec pause (code done) Application. Send keys "^{p}" it opens print Then I gave few sec again Then I Application. Sendkeys"^{enter or~ } It not perform enter Even I used your tab Key techniques till print then send enter that also not work Later I seen print in webpage therefore I inspect, rest you know above element is print tabs Class
@@AutomationMadeEasy Is there any way out to scrap data from a webpage which we have opened manually in our MS edge. I have checked multiple times regarding this but i didn't land up with some positive results. Please help me out. The above error is resolved, Many thanks for that.
Browser will close by default after last line of code is executed. To avoid browser being closed define the webdriver object outside the sub as given below: Dim obj As New WebDriver Sub test1() obj.start "edge","" ''Remaining code End Sub
I tried this in Access VBA (shouldn't make a difference to Excel) and when i run the Start command, I get an automation error. Do you know why? Thank you
Dot net framework 3.5 may be missing.Follow below steos: On windows start button type features You will see 'Turn Windows features on or off' Click on it On next window you will see list of options Search for .net framework 3.5 Select that option Save and close Reboot and execute your macro
@@AutomationMadeEasy I'm very happy to have found your tutorial even though I tried this before but didn't get it to work, and gave up on it. I'm coming from having written code to automate the webrowser control with IE. Oh I was worried that we'd have lost update of a vital resource. This gives some hope. Do you know of any book for this object model? I'm used to webbrowser's way of accessing tables, rows, and other elements. This has a different interface altogether. I would like to have a clear understanding of it's structure. I didn't get to the end of the video yet. Maybe I won't need a book after all
How do you go about entering dynamic values? Let's say in the case of the date drop-down, I wanted to select the current date, or date offset by some specified number of days, how would this be done?
Web site will close after the last line of the code is executed. If you want to prevent that put Dim obj As New WebDriver on top of Sub as shown below: Dim obj As New WebDriver Sub test1() obj.Start "edge","" '--- Remaining code End Sub
dot net framework 3.5 must be missing. Install using below steps. 1. Type 'Features'in Windows search box 2. Select Turn Windows Featurs on and Off'' 3. First option would be dot net 3.5 4. Select that option 5. Click ok to download 6. It will take a while to have the downloaded completed 7. After download completes restart your system 8. Now execute your macro
Future on and off of the Under 2 option show is the No. 1 Windows Communication Foundation Http Activation, no. 2 Windows Communication Foundation non-HTTP activation Which of these to select?
you must have option of dot net 3.5. dot net 3.5 is needed to avoid automation error. You can send snapshot of turn on off features on info@automationandagile.com I will takea look and revert.
thanks a bunch. I still have to build the macro I need, but this was really useful and very well explained. 👍 I've kept a shortcut to your video so that I can share it with some friends who would be interested in doing edge automation too. I'll ask them to give a thumbs up when they come. bye, and thanks again. 🙂
ur welcome
Excellent content. I've been looking for a long time for something so detailed and really functional. Thanks.
Glad it was helpful!
I had to change the Year field name from "day" to "year" in the HTML code to be able change the year value. If I were the only one to have this problem, there is something I am missing. But thanks for the info. It really helped me.
Your welcome
you are awesome. I`m creating new codes in my work to get more accuracy in data, and you really help me a lot. Cheers from Argentina
Glad to know.
This was super awesome. All the different trials i found out here were giving me errors. thank you very much
Glad you enjoyed it!
Excellent!!! Thank you very much. This is what I have been looking for a very long time.
Glad it was helpful!
I haven't done Excel VBA programing since 2008. Could not find a job doing it, since no formal training. Learned on my own by reading help files.
Your videos are filling in the details where I missed earlier in my attempts.
I did send automated emails, but didn't use the Outlook library at the time. It was Excel 5.0, so couldn't do it with newer Excel versions.
Great to hear!
Thank you much! Very useful, especially the Xpath sample helped me a lot! Have a great day!
Your welcome
Thank you this was a very clear presentation I could follow real time.
Glad it was helpful!
Thank you very much! You made my day!
I'm glad!
you are a great person, and you should feel good about it.
thank you for your amazing work.
So nice of you
U are awsome. This was very useful and informative information. U have done fantastic job ... The way you explain is also very good.
Thank you so much 🙂
Love you so much.
Great Tutorial Thank you, Sir .. very clear instruction .. but when I have tried to navigate to an already logged-in site I need to log in again & again each time.. so how to navigate a site without the need to re-login...
It will always open a new session
Your video has been of great help to me. Excellent explanation and keep up your great work. Greetings from Mexico 😊
Glad it helped!
Greetings. I have followed the steps as you show to start a project and I get an automation error in the line: obj.Start "edge","". what should it be?
Dot net 3.5 might be missing. Search for Features on windows serach bar on the bottom of the desktop. Select Turn windows featurs on or off. Select dot net 3.5. Install it. Close all your excel workbooks.Open the workbook in which tou have written the script and execute.
@@AutomationMadeEasy Thank you very much. Now it works perfectly.
@@AutomationMadeEasy I have problems to be able to activate the following button that appears in a floating dialog box:
Enterado == $0
I would appreciate guidance.
You are big!! Thanks!
You're welcome!
Thanks for Sharing. Really informative. Getting Automation error please suggest how to resolve it
Thanks.
Dot net framework 3.5 might be missing
Close of Excel workbooks
Click on Start Windows icon
Search for features
Click on Turn Windows features on or off
On the next window select dot net framework 3.5
Download and install
Now retry
TL;DR: If you follow the steps in the video, and you get "Automation Error" when running your code, you might need to install .Net Framework 3.5, even if you have a later version.
Thank you for doing such a thorough video.
I am having a problem, though.
When I run this code
Dim WD As New WebDriver
WD.Start "edge", ""
On the WD.start line, I get: Automation Error.
Previously, I had:
Dim WD As New WebDriver
Set WD = New WebDriver
and the Set line also returned: Automation Error.
My Edge version is 90.0.818.66. I copied the MSEdgeDriver into the selenium folder (and renamed it).
Where should I look to troubleshoot this?
I was just thinking: I used the x64 version. Do I absolutely need the x86?
Tried it. That wasn't it.
Turns out I needed to install .Net Framework 3.5 (despite already having .Net Framework 4.8). I discovered this when I tried to run
C:\Users\Username\AppData\Local\SeleniumBasic\Scripts\StartEdge.vbs
Thank you so much for the trouble shooting advice. That fixed worked for me.
Very informative...can we get object of already opened edge also
unfortunately no
Thank u for this very informative video. Is it possible to open multiple chrome profiles at once and use the script to fill out forms on those profiles? Thank uu
not with excel vba
This is what I was looking for, just a quick question. If I wrote some code for web scrapping and someone else want to run it on their system do they have to install Selenium on their system as well?
yes installation is mandatory
Might get an AI interpreter job. Plan to do voice to text, then go to the website.
I presume that I will need the speech to text library downloaded or checked.
Thanks for the clear video, my VBA test code works. I'm just wondering if we now have to download the web driver again, rename it and put it in the correct folder with every update of edge?
unfortunately yes, but it will happen around once in 2 months
@@AutomationMadeEasy Can't we automate that? :) :)
Thanks for confirming.
Is there a way to open multiple tabs and run the script?
Parallel execution not possible with excel vba. Though it can move to other tab if a page open on a separate tab
Thank u for the video, i have a challenge and need help, Start and Get open a new instance of edge, how i can assign an already opened instance of edge to an object. My web page is already opened and i want to parse data, using Get and Start will reopen the page, is there a way to assign current open page to the object.?
By default it will open a new browser session
Thank You. Can you please show how to navigate to another browser window and perform some actions on it using excel macro? How to handle multiple browser windows?
will upload a tutorial
Is it possible to do this in an existing window in edge? Great video by the way thank you!
Unfortunately not
Hi, this is an excellent tutorial. I was wondering if you could help with an alternative to "Selenium Basic"? I am afraid my organization's IT department may not approve it. Is there an Excel Add-in?
No alternative I can think of.Selenium should be approved as it is a very well known automation tool being used in almost all organizations
Hello brother, great video it helped. By the way, now that we have built this macro, how do we send data from excel columns to the website? Do you have a separate video for that?
P.S. I am a complete begineer.
refer below tutorial:
ruclips.net/video/docnLSdj8rI/видео.html
Thank you very much for all your videos and I been learning a lot with all of them. This is almost my Netflix if you know what I mean. Can I use this on a page where I have to login to my account and then find the form?
Thanks for the kind words.
Yes you can use on the login page as well. Let me know if you need any custom automation.
@@AutomationMadeEasy thank you for quick reply! If the page has a login, then a user page with a form, do I follow this tutorial the same way. Meaning I add the URL, but when it asks for a login, what do I do? Thanks again and great job!!
yes just follow the same steps and treat usrname, pswd fields as any other fields
@@AutomationMadeEasy thank you! helped a lot! you're a genius!
Thank you so much.
You're welcome!
Need help, If the browser version gets updated in the system, We have to update the same in Selenium Basic, Is it possible to get auto-updated in selenium basic
Using the video I could write the code(using edge and leaving IE) for logging into this site(identifier, password, etc..),
In my former "IE written" code I used a handle to do several things on this site:
Is it always possible to get such a handle, or should I code in a different way?
Great Video.
I tried implementing it
the bowser opens and navigates to the URL provided
but it closes automatically in like 5-6 seconds
is there any solution for this issue?
It will close after the last line of the code is executed. It wont close until there are lines of code to be executed.
This was really great. After submitting the data from Excel to Edge, I want to retrieve the result on the web page. Can you tell me how to do that?
Thanks. It depends on the web page and the field which you wish to access.
great one... thank you.... is there any possibility of doing this (autoamting edge tasks) without selenium? Also, wondering if I use selenium and create a macro and want to share it with other people, do they need to have selenium installed in their system for this macro to work?... thanks in advance
Selenium is mandatory on the system where the macro will be executed
Thank You !! But I just want to know is there any way to make connection with EDGE using VBA only without installing any additional software. Please do the needful.
installation is mandatory
Very useful.
How to automate vba for multiple dates with times in hr, min, seconds
Kindly guide
well dates have different formats both on excel and web pages. It all depends how the web page expects it, so there isnt any generic solution. Custom code would be needed as per the design aof the web page.
Great Video! How do I get this to work from an already open edge window?
Thnx. It will open a new session always
Thanks
Welcome
Thanks for your video I am having one more doubt we need to achieve this autimation we have to install each every user for selinium basic application then only this can be achieved or is there any another option without installation for selinium basic for all the user we can automate or not thanks in advance.Can you application
installation on the system is mandatory
thanks for the video.
how can we extract information from an edge website by vba
Thanks for these wonderful videos on web automation using vba. I was looking for VBA automation for downloading JSON object which is parsed from a different url. So, if we check the link in edge json object text appears. But in ie a pop up appears asking to save the object. Do not know how to automate and download this object using vba. Any suggestion? Unable to share the url/link due to security reasons. Thank you again for these amazing videos. this is Great Learning
will need to see to suggest a solution
So if I am building this macro enabled spreadsheet to utilize this process with filling in edge forms and each person's computer has a different version of edge, will this work? If not, how can I make a version that can be shared with others with different version of edge? If there isn't, there has got to be a reliable way to doing this for people that share the same process.
edge driver will need to be updated as and when a newer version is published
Hello.. thank you so much.. is there a way we can automate edge without selenium
unfortunately no
your video was very helpful to me thank you, but i need to update data from excel(more then 2 line) to web portal and submit with ok popup button, please guide
For multiple rows refer below tutorial:
ruclips.net/video/docnLSdj8rI/видео.html
For message box use below code:
obj.SwitchToAlert.Accept
How to select all text page web = Ctrl+A with script vba if the web only has & element
Great video! It's a very clear guide. While I have the following problem: Run-time error'-2146233078(80131150a)': The source was not found, but some or all event ligs could not be searched. Inaccesible logs:Security.
bug line: obj.Start "edge", ""
Same error occur
What is sollution ?
hello, its there any option that does not require installing selenium basic since i planned to share the program to other clients that are not familiar with stuff like software installation.
Nopes. Set up mandatory
Thanks for great tutorial. Automation works, but Edge closes in end. How to leave Edge open after Submit button is pressed?
browser will close after the last line of code is executed by default.
If you want browser to remain open but a message box at the end . The browser wont close until the message box is dismissed. Syntax given below:
MsgBox "Wait"
is there a way to get around edge using browser based pop ups when automating through a vba?
bot.alerts.accept
Is there a way to control pop-up window like file dialog box which will get the file path to be uploaded in a webpage or portal.
you can use the approach explaind in below tutorial:
ruclips.net/video/7a8IofqBNo4/видео.html
I have a div inside that there are many img tag with src links..how can get all those..can you please help me
need to see the html of the web page
Thanks for your video, it's very helpful. I have a problem in first syntax. It always appearing "run-time error '-2146232576 (80131700)': Automation Error". If I click on debug, the line "obj.Start "edge", "" " highlighted. I assumed there is a problem in my edge, but when I tried your tutorial for chrome, the same problem occured again. Any suggestion?
dot net framework 3.5 must be missing. Install using below steps.
1. Type 'Features'in Windows search box
2. Select Turn Windows Featurs on and Off''
3. First option would be dot net 3.5
4. Select that option
5. Click ok to download
6. It will take a while to have the downloaded completed
7. After download completes restart your system
8. Now execute your macro
@@AutomationMadeEasy Thank you. Was getting same error and this worked
@@reginamaybee5359 Your welcome.For customized automated solution write into info@automationandagile.com
@@AutomationMadeEasy I've had the same problem. Unfortunately, it's still not working out even after installing framework 3.5! Maybe because I work in a company which I don't have administrator permission to do some IT operations due to security policy. Even so I could install it without any error except this one I mentioned. I also changed the edgedriver.exe to both version, 64 and 86, no change! Does someone know what it's going on? I have no idea!
@@AutomationMadeEasy did follow the steps but getting other error after . It always appearing "run-time error '-21: Timeout Error". The driver failed to opn the listening port 127.0.0. 1:49899 . If I click on debug, the line "obj.Start "edge", "" " highlighted.
Can I achieve the same automation without selenium
unfortunately no
when I ran the macro, the Edge closed by itself immediately after being loaded. do not know why? it also showed an info bar on top "Microsoft Edge is being controlled by automated test", any suggestion to fix the issues? thanks
thats default behaviour browser will close after last line of code gets executed.
if you want to keep browser open keep the Dim obj as New Webdriver out side of Sub as given below
Dim obj As New WebDriver
Sub test12()
'Your code
End Sub
@@AutomationMadeEasy this worked well. thank you so much
Edge browser just opening and closing after some time?
I am using excel 2007
is there any possibilities to do it without the selenium? at company i'm working i can't download anything
nopes
I cant force my users to use Internet Explorer or Edge. Assuming the user selects their browser from a drop-down menu, is there any way to automatically fill in the web form if its in Chrome, Firefow or Opera browser instead?
this technique with excel supports chrome and edge.
@@AutomationMadeEasywill my clients need to have selenium installed to run the macro? I don’t think I can expect them to do that. Can it work without them doing downloading anything special?
its like any other software. Minimum one installation would be needed.Other solutions may be feasible but for that I need to see the web page to assess.
Unfortunately, I receive an automation error on the line " obj.Start "edge", "" ". The same happens with Chrome. Do you know what might be causing an issue?
My version of Edge is "123.0.2420.81 (Official build) (64-bit)" and I have up to date web driver for it..
Thank you in advance!
check if u have dot net 3.5 installed
@@AutomationMadeEasy Thank you for a quick reply! :)
hello, how can load undetected-chromedriver with SeleniumBasic in vba? thnaks
not feasible
Hi, I logged in successfully in a wedsite, but once the code finished the run time the edge browser is closing. I want it to stay visible. Please help. But great tutorial. Thank you.
Thats default behaviour. Put a message box as shown blow. Browser wont close until message box is dismissed.
MsgBox "Wait"
@@AutomationMadeEasy Hi Thank you, Yesterday, i successfully logged in to facebook and posted a status. Thanks for the idea.
how to extract the data from edge browser can u please post the video on this topic
Bro agar list of websites ho toh kese aur kya karna hoga
Hi, how do I insert date in web form , in the web form when I manually click it opens a calendar, I have date in excel how do I get in form , please help
need to see the date control.
Why does the page close after the code runs? What could be the problem?
thats by default
if you want the browser to remain open. Put
Dim obj As New WebDriver on top of begining of sub. Example given below:
Dim obj As New WebDriver
Sub test1()
'======
End sub
Without any download can able to use vba marco
I followed all the steps and downloaded the edge driver, and when executing the code, an error is given when this code reads: "obj.Start "edge"," "Please, what should I do?"
did u change the deiver name?
good afternoon,
I followed all the steps and managed to start.
So that as soon as you open the site, it automatically disappears / closes.
What will be the problem?
greetings
by default it will close after last line of code is executed
I trailed with Year, But its not Accessing may i know what is reason behind it
didnt get your question.Can you elaborate?
Don't want to use senkeys ....I want to pick value from Sheet1 column 2 row 3.....plz help
I am using edge browser
assuming sheetname is Sheet1
var strname = ThisWorkbook.Sheets("Sheet1").Range("B3").text
obj.findElementbyId("id of element").sendKeys(strname)
You will have to use senkeys but value ypu can store in a variable.
How to use it with existing browser tab...
not feasible
edge just close itself when it finish operation is there a way to avoid it?
put a message boc just before the last line.it wont close until you click the message box. Syntax given below:
MsgBox "Wait"
@@AutomationMadeEasy thank you
Print
Thanks bro for response but have a problem
run time error 7
No such element error
Element not found for
Xpath=//*[text()='print']
Purpose :print form save as PDF
My previous method
It filled all forms then I give
5 sec pause (code done)
Application. Send keys "^{p}" it opens print
Then I gave few sec again
Then I
Application. Sendkeys"^{enter or~
}
It not perform enter
Even I used your tab Key techniques till print then send enter that also not work
Later I seen print in webpage therefore I inspect, rest you know above element is print tabs
Class
need to see the web page
I am unable to find my edge driver version in the downloads and was not able to access the website which navigated it was being forced to close when I run the program
what is the version of your edge browser?
Hi. I am trying to figure out a way to get to the element that is in a DIV but there are two on the page. The only thing different is the text in the tag: Cancel - then in the second one instead of cancel it says Refund. I always need the 2nd one. I cannot figure out a way to find it. BTW: your videos are great! I have watched many. Thank you
Can I skip 1? It works if I want the first one.
try this
obj.findElementByXpath("//*[@class='continueBtn btn btn-danger']").click
If it does not work share url of the web page I will help you correctly identify it.
Bro how to use this in Google shuffle forms without elements name and I'd any idea
refer below tutorial:
ruclips.net/video/DVRM7VLKUFU/видео.html
Close
inspect element aisa hain ek colse likha hua aa raha hain close pe click karna hain vba code bataiye
obj.FindElementByXpath("//*[text()='Close']").click
When trying to open edge Brower using the technique.. I get a message and edge closes immediately .
"Microsoft Edge is being controlled by automated test software"
Win 10 64 bit. | Edge Version 96.0.1054.34 (Official build) (64-bit)
browser will close after the last line of the code is executed by default.
@@AutomationMadeEasy True. Apologies I should have mentioned that in my case it was first line within the sub that closed the browser..
But anyways now it is fixed, a computer restart did the trick. Thank you for trying and the helpful video.
Print
For edge how to define .click on above element using which find element
only class is available above what to do bro ?
try obj.findElementByXpath("//*[text()='Print']").click
@@AutomationMadeEasy
Thanks bro for response but have a problem
run time error 7
No such element error
Element not found for
Xpath=//*[text()='print']
Purpose :print form save as PDF
My previous method
It filled all forms then I give
5 sec pause (code done)
Application. Send keys "^{p}" it opens print
Then I gave few sec again
Then I
Application. Sendkeys"^{enter or~
}
It not perform enter
Even I used your tab Key techniques till print then send enter that also not work
Later I seen print in webpage therefore I inspect, rest you know above element is print tabs
Class
I did followed all steps , but i am not able to establish a connection in ms edge , Not sure if you can see my comment.
Thanks in advance
what is the error you are seeing?
@@AutomationMadeEasy
Is there any way out to scrap data from a webpage which we have opened manually in our MS edge.
I have checked multiple times regarding this but i didn't land up with some positive results. Please help me out.
The above error is resolved, Many thanks for that.
When it gets to the first part, open Edge at the URL, mine opens the browser, goes to the site, then closes the browser.
Browser will close by default after last line of code is executed. To avoid browser being closed define the webdriver object outside the sub as given below:
Dim obj As New WebDriver
Sub test1()
obj.start "edge",""
''Remaining code
End Sub
Nice job. I'm getting an error with the check box. Run-time error 11: ElementNotVisibleError element not interactable.
Every other thing works perfectly
great to know
@@AutomationMadeEasy I mean every order thing works but the check box
Hello, can anyone help with how to handle alert pop ups in edge? I have an are you sure pop up which kills my Macro, any help would be great.
obj.SwitchToAlert.Accept
@@AutomationMadeEasy Superb, thank you. Love you channel so simple
I am getting error while running the code, chrome was not starting, please anyone can help me
This is not for chrome. For chrome you need to declare the driver element as Selenium.ChromeDriver
how to open and close tabs in edge
Execution error 429
the component ActiveX cannot creat object
I m getting a Automation error not able to launch Chrome aur Egde through this code can you please help
dot net 3.5 might be missing
after starting macro edge start correctly and after close !!!
thats default behaviour.browser will close after last line of the code gets executed. Brower will close until there are lines of code to be executed.
I tried this in Access VBA (shouldn't make a difference to Excel) and when i run the Start command, I get an automation error. Do you know why? Thank you
Dot net framework 3.5 may be missing.Follow below steos:
On windows start button type features
You will see 'Turn Windows features on or off'
Click on it
On next window you will see list of options
Search for .net framework 3.5
Select that option
Save and close
Reboot and execute your macro
@@AutomationMadeEasy thank you. That did the trick
@@AutomationMadeEasy I'm very happy to have found your tutorial even though I tried this before but didn't get it to work, and gave up on it. I'm coming from having written code to automate the webrowser control with IE. Oh I was worried that we'd have lost update of a vital resource. This gives some hope. Do you know of any book for this object model? I'm used to webbrowser's way of accessing tables, rows, and other elements. This has a different interface altogether. I would like to have a clear understanding of it's structure. I didn't get to the end of the video yet. Maybe I won't need a book after all
How do you go about entering dynamic values? Let's say in the case of the date drop-down, I wanted to select the current date, or date offset by some specified number of days, how would this be done?
You wil have to provide data in an excel spreadshhet. Read the data from the excel and write the same on the web form.
Completed
Sir Dropdown se se Completed kaise select karenge
need to see html of entire page
when im running code to open edge brouser it is showing error
Sir opera ke liye kaise karenge uska driver kahan milega pls help
Not Feasible
Code opens website but can never find any of the elements
Web site will close after the last line of the code is executed. If you want to prevent that put Dim obj As New WebDriver on top of Sub as shown below:
Dim obj As New WebDriver
Sub test1()
obj.Start "edge",""
'--- Remaining code
End Sub
HI Team,
Kindly explain or provide code on who to automate file upload (browse file) and select one file and close window .
After clicking on browse button you can use the tab and enter keys as given below:
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run "cmd.exe /c echo " & strUploadFile &"|clip", 0, True
Application.Wait DateAdd("s", 2, Now)
obj.FindElementByXPath("//*[@class='wpsm_tax_helper_upload_image_button button']").Click
Application.Wait DateAdd("s", 2, Now)
Application.SendKeys "{TAB}"
Application.Wait DateAdd("s", 2, Now)
Application.SendKeys "{TAB}"
Application.Wait DateAdd("s", 2, Now)
Application.SendKeys "^{v}"
Application.Wait DateAdd("s", 2, Now)
Application.SendKeys "{TAB}"
Application.Wait DateAdd("s", 2, Now)
Application.SendKeys "{TAB}"
Application.Wait DateAdd("s", 2, Now)
WshShell.SendKeys "{ENTER}"
@@AutomationMadeEasy Please provide your contact number no, so that i can explian the issue
Getting below error message
Run-time error '0'
Selenium error
Invalid argument
(session info : *
Driver info: *
platform = window _X86_64)
Did you checj the driver and browser version?
share your contact info I will get in touch.
Not working for dependent drop down?
It should work. If you need assisstance write into info@automationandagile.com
@@AutomationMadeEasy will it work on "I am not a robot" also
this will need manual intervention
sir please create fresh video as this is very old now a days its not working i need your help
what is the error. Its working alright
Hello
The module is showing an (automation error) after running
Plz help
dot net framework 3.5 must be missing. Install using below steps.
1. Type 'Features'in Windows search box
2. Select Turn Windows Featurs on and Off''
3. First option would be dot net 3.5
4. Select that option
5. Click ok to download
6. It will take a while to have the downloaded completed
7. After download completes restart your system
8. Now execute your macro
Future on and off
of the Under 2 option show is the No. 1 Windows Communication Foundation Http Activation,
no. 2 Windows Communication Foundation non-HTTP activation
Which of these to select?
which operating system you are using?
@@AutomationMadeEasy
Window 10
you must have option of dot net 3.5. dot net 3.5 is needed to avoid automation error. You can send snapshot of turn on off features on info@automationandagile.com I will takea look and revert.
error in the line : obj.Start "edge", ""
whats the error?
Your content is great but the voice quality is bad