I want to use for Google chrome. Sometimes in dropdown list, macro select wrong name in list simitiar to our value, for example I want to select value AAAB from drop down, macro will select AAAA by mistake, how to select exact as any cell value in excel.?
Hi... I have a web page which has a hover section leads & it has two sub menus - submit & edit.... So basically I wanna click on leads & then on submit.... So how will I able to do that?
Thanks for uploading this. Your tutorials are very easy to understand and has helped me to create a macro to make my work easier. I hope you can help me on this. Is there a way to click the button after opening the webpage, if the button has no ID, name, class assigned to it? All it has is
Get element by id or name is it only for INPUT categories? What if we do not find and input line on webportal. The button need to click has only div, table, button. I hope you understood my problem, since i do not know technical terms. This is the first time i am doing these. Suceeds lot of thing but i have stuck on one point.
Hello Sir, I am trying to autofill data in a web modal form but there is no id, no name, no classname. The link is like: How to can I click on the tag to open modal popup. Please help, it's like very urgent.
I got an error Runtime error - 80004005 , Method 'document' of object 'Iwebbrowser2' failed and changed it to Set IE = New InternetExplorerMedium, no getting ant error as Runtime error 91, Object variable or with block variable not set
Hello There, Can you please help me to get the data when we have two HTML Sections? Path is like - HTML>FrameSet>Frames>HTML>Forms>Tables>Submit..... Now I want to click Submit Button. Able to get data from 1st section of HTML but unable to go into 2nd HTML section.
@automation made easy Your code is very helpful thanks for it 😀 While executing code continuously sometimes I am seeing "Microsoft Visual Basic" pop up with Run time error showing buttons End Debug. Can you please help with automation code where whenever this pop up appears click on END button and continue with the script. Issue: I run the script on edge for 1000 rows but in between it shows runtime error saying elementid is not found at 101 row for example but it worked fine 100 times, when I click on End manually and run the script again it works perfectly fine. Instead of me manually clicking on END everytime if it can be automated it will be helpful.
error occurs because of error at the execution time. Ideally the error must be properly handled but if you want to ignore it put On Error Resume next after Sub. Example given below: Sub test1234() On error Resume NExt '' code ''code End Sub
@@AutomationMadeEasy thank you so much this helped 🙏 One more query added edge start as following can you also please help with command to close edge browser: obj. Start "edge", " " Scenario: I would like to close the browser whenever I see failed text and execute the code from start
@@AutomationMadeEasy thank you 😀 code is successfully running as expected. I would like to add data to excel which is not coming from webpage while automation. EXAMPLE: element details are not available and webpage closes in fraction of seconds. In that case is there a way to just input value as "test" under Column H of excel. Please help I tried following: ThisWorkbook.Sheets("Sheet1").Range("H" & intRow).Text = "Test" In the else block
Hello , All your tutorial videos are very useful and informative. But I am not able to write a script click a button for the following HTML .So could you please help me to write the script. I have mentioned the script which i have created. Header InformationHeader Information Sub copy_project_loop() Dim IE As Object Dim Doc As HTMLDocument Set IE = CreateObject("InternetExplorer.Application") Dim SHELL_OBJECT SHELL_OBJECT = "WScript.Shell" Set objShell = CreateObject(SHELL_OBJECT) IE.Visible = True IE.navigate "URL" Do While IE.Busy Application.Wait DateAdd("s", 1, Now) Loop Set Doc = IE.document
'Click Header Information Tab under Time Study
Doc.getElementById("docIcon47").Click
Doc.getElementById("txtTimeStudyNbr").Value = ThisWorkbook.Sheets("data").Range("A2").Value End Sub
Very good
Thanks
Really helped your video,searching from last 2 days to get this methods
Glad to hear that
Your videos are tuning as I am in search of..it is really beneficial to me
This is really helpful.. I can get the data from the excel and submit. But how to repeat this for the 100 rows.??
I want to use for Google chrome. Sometimes in dropdown list, macro select wrong name in list simitiar to our value, for example I want to select value AAAB from drop down, macro will select AAAA by mistake, how to select exact as any cell value in excel.?
For chrome browser refer below tutorial:
th-cam.com/video/-GUw22ecRwI/w-d-xo.html
Hi... I have a web page which has a hover section leads & it has two sub menus - submit & edit.... So basically I wanna click on leads & then on submit.... So how will I able to do that?
Thanks for uploading this. Your tutorials are very easy to understand and has helped me to create a macro to make my work easier.
I hope you can help me on this. Is there a way to click the button after opening the webpage, if the button has no ID, name, class assigned to it? All it has is
Glad it helped!
Can you share the link of the page?
@@AutomationMadeEasy unfortunately i can't share the page as it's work related
Amazingly useful. I love you.
Glad it helped!
What would the Set doc be = for Microsoft Edge? Thanks.
this approach wont work on edge
Get element by id or name is it only for INPUT categories?
What if we do not find and input line on webportal.
The button need to click has only div, table, button.
I hope you understood my problem, since i do not know technical terms. This is the first time i am doing these.
Suceeds lot of thing but i have stuck on one point.
share url of the page
Very good sir, maja aa gya dekhkr
your welcome
Can you please show to automate web page on Mac with M1 chips using Excel.
This is very helpful. I have one question thou how can get element in cases where I only have “Class, and Ng init) please help. THANKS
Use the approach explained in below tutorial:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
thanks dear thanks very much I'm learning from you, sir.
Glad to hear that
@@AutomationMadeEasy hi ..
Am getting error 91 on executing
How to execute it in already opened browser...
refer below tutorial:
th-cam.com/video/qsU_9KVaYOU/w-d-xo.html
Hello Sir, I am trying to autofill data in a web modal form but there is no id, no name, no classname.
The link is like:
How to can I click on the tag to open modal popup.
Please help, it's like very urgent.
refer alternate approach explained in below tutorial:
th-cam.com/video/9GbHCO4Lp-0/w-d-xo.html
What will be the syntax,if drop down options are loaded after selecting the previous value? Please reply
Syntax will remain the same. You may have to put some delay to have the values populated in the dependent dropdown
Hello! Can you please provide demo on API Testing ??
noted
Hello, when I select a value from the list using the code, it stays over it and does not select it, is like it needed press enter, thanks for help
Try alternate approch explained in below tutorial:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
When I'm tricking to click option in getelementsbyclassname it's throwing error.... Is there any other option
share ur code.
I got an error Runtime error - 80004005 , Method 'document' of object 'Iwebbrowser2' failed and changed it to Set IE = New InternetExplorerMedium, no getting ant error as Runtime error 91, Object variable or with block variable not set
Try on already opened browser. It is explained in below tutorial:
th-cam.com/video/qsU_9KVaYOU/w-d-xo.html
Hello There, Can you please help me to get the data when we have two HTML Sections? Path is like - HTML>FrameSet>Frames>HTML>Forms>Tables>Submit..... Now I want to click Submit Button. Able to get data from 1st section of HTML but unable to go into 2nd HTML section.
need to see the web page
Same method I am trying in another website but it is not working..if possible can you help me out
try below:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
Can you make videos on Selenium web driver in excel, from which we can control google chrome.
refer below tutorial:
th-cam.com/video/-GUw22ecRwI/w-d-xo.html
@@AutomationMadeEasy Thanks bro
Hi sir, Am getting on error while automating on web app .error 91..
Object variable or with block not set
share ur code
@@AutomationMadeEasy how to contact you
share ur contact info I will get in touch or write into info@automationandagile.com
Any special reason for using the "without id's " approach?
many elements may not have id's. so these techniques come in handy
@@AutomationMadeEasy Thanks a lot!
Hi, how i find number's class name or name if the page is so big?
Numbering is sequential left to right top to bottom
Bro when using ie, if there is no name, id, class how to select webelement
there shall be somethig in the html to identify it.
Hi u are doing good, one request userid and password shd be automatically done and it after loggging it shd be navigated to next page
just apply the same logic for username and pswd and it will work
HI,
Can we automate firefox using vba.
not Firefox but you can automate edge and chrome. Refer below tutorial:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
@@AutomationMadeEasy Thanks.
How can I thank you man.... Thank you so much
Happy to help
why error doc.Document ???
didnt get you. Please explain the issue in detail
Hello Automation made easy.i need you help could you please help me how can i contact you?
@automation made easy Your code is very helpful thanks for it 😀
While executing code continuously sometimes I am seeing "Microsoft Visual Basic" pop up with Run time error showing buttons End Debug. Can you please help with automation code where whenever this pop up appears click on END button and continue with the script.
Issue: I run the script on edge for 1000 rows but in between it shows runtime error saying elementid is not found at 101 row for example but it worked fine 100 times, when I click on End manually and run the script again it works perfectly fine. Instead of me manually clicking on END everytime if it can be automated it will be helpful.
error occurs because of error at the execution time. Ideally the error must be properly handled but if you want to ignore it put On Error Resume next after Sub. Example given below:
Sub test1234()
On error Resume NExt
'' code
''code
End Sub
@@AutomationMadeEasy thank you for quick reply I will try this 😃
@@AutomationMadeEasy thank you so much this helped 🙏
One more query added edge start as following can you also please help with command to close edge browser:
obj. Start "edge", " "
Scenario: I would like to close the browser whenever I see failed text and execute the code from start
obj.close
@@AutomationMadeEasy thank you 😀 code is successfully running as expected.
I would like to add data to excel which is not coming from webpage while automation.
EXAMPLE: element details are not available and webpage closes in fraction of seconds. In that case is there a way to just input value as "test" under Column H of excel. Please help
I tried following:
ThisWorkbook.Sheets("Sheet1").Range("H" & intRow).Text = "Test"
In the else block
This is helpful ... Thank you ..
I am facing some issues and details mail to you, please check and suggest.
refer below alternate approach:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
Hello , All your tutorial videos are very useful and informative.
But I am not able to write a script click a button for the following HTML .So could you please help me to write the script. I have mentioned the script which i have created.
Header InformationHeader Information
Sub copy_project_loop()
Dim IE As Object
Dim Doc As HTMLDocument
Set IE = CreateObject("InternetExplorer.Application")
Dim SHELL_OBJECT
SHELL_OBJECT = "WScript.Shell"
Set objShell = CreateObject(SHELL_OBJECT)
IE.Visible = True
IE.navigate "URL"
Do While IE.Busy
Application.Wait DateAdd("s", 1, Now)
Loop
Set Doc = IE.document
'Click Header Information Tab under Time Study
Doc.getElementById("docIcon47").Click
Doc.getElementById("txtTimeStudyNbr").Value = ThisWorkbook.Sheets("data").Range("A2").Value
End Sub
Try this:
Doc.getElementsByName("docIcon47")(0).Click
@@AutomationMadeEasy
I Tried this i am getting Run-time error '91':
Object variable or With block Variable not set
i will need to see the actual page to suggest a solution
Amazing man, how can I contact you, insta, FB or whstapp?
share ur contact info I will get in touch or write into info@automationandagile.com
@@AutomationMadeEasy 8448774634 WhatsApp