Really helped your video,searching from last 2 days to get this methods
@AutomationMadeEasy
3 жыл бұрын
Glad to hear that
@jintubayan7471
3 жыл бұрын
Your videos are tuning as I am in search of..it is really beneficial to me
@mahimanasa1
3 жыл бұрын
This is really helpful.. I can get the data from the excel and submit. But how to repeat this for the 100 rows.??
@mc24bk
3 жыл бұрын
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
@AutomationMadeEasy
3 жыл бұрын
Glad it helped! Can you share the link of the page?
@mc24bk
3 жыл бұрын
@@AutomationMadeEasy unfortunately i can't share the page as it's work related
@Dog_Extreme_2000
3 жыл бұрын
Amazingly useful. I love you.
@AutomationMadeEasy
3 жыл бұрын
Glad it helped!
@jadonsumit786
4 жыл бұрын
thanks dear thanks very much I'm learning from you, sir.
@AutomationMadeEasy
4 жыл бұрын
Glad to hear that
@angelzworld5007
4 жыл бұрын
@@AutomationMadeEasy hi .. Am getting error 91 on executing
@sunelidberg9503
3 жыл бұрын
Very good
@AutomationMadeEasy
3 жыл бұрын
Thanks
@ANNUETAWAHCRPF
4 жыл бұрын
Very good sir, maja aa gya dekhkr
@AutomationMadeEasy
4 жыл бұрын
your welcome
@DigitalBankingIndia
4 жыл бұрын
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.?
@AutomationMadeEasy
4 жыл бұрын
For chrome browser refer below tutorial: kzitem.info/news/bejne/jn2L3WZonpWDqn4
@travellerschoice2118
3 жыл бұрын
Can you please show to automate web page on Mac with M1 chips using Excel.
@sawdahjaulim700
3 жыл бұрын
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
@AutomationMadeEasy
3 жыл бұрын
Use the approach explained in below tutorial: kzitem.info/news/bejne/onumlo2boqVqdII
@GiridharPedapudi
4 жыл бұрын
How can I thank you man.... Thank you so much
@AutomationMadeEasy
4 жыл бұрын
Happy to help
@shivanipandey8453
4 жыл бұрын
Hello! Can you please provide demo on API Testing ??
@AutomationMadeEasy
4 жыл бұрын
noted
@Radog99
Жыл бұрын
What would the Set doc be = for Microsoft Edge? Thanks.
@AutomationMadeEasy
Жыл бұрын
this approach wont work on edge
@anuishwarya6601
3 жыл бұрын
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
@AutomationMadeEasy
3 жыл бұрын
just apply the same logic for username and pswd and it will work
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?
@Isuru8Hewage
4 жыл бұрын
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.
@AutomationMadeEasy
4 жыл бұрын
share url of the page
@MyTechOnlineSupport
3 жыл бұрын
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.
@AutomationMadeEasy
3 жыл бұрын
refer alternate approach explained in below tutorial: kzitem.info/news/bejne/mn2YrneFbX6hYGU
@omkarmohanty846
3 жыл бұрын
What will be the syntax,if drop down options are loaded after selecting the previous value? Please reply
@AutomationMadeEasy
3 жыл бұрын
Syntax will remain the same. You may have to put some delay to have the values populated in the dependent dropdown
@jintubayan7471
3 жыл бұрын
Same method I am trying in another website but it is not working..if possible can you help me out
@AutomationMadeEasy
3 жыл бұрын
try below: kzitem.info/news/bejne/onumlo2boqVqdII
@TanveshDabholkar
4 жыл бұрын
Can you make videos on Selenium web driver in excel, from which we can control google chrome.
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
@AutomationMadeEasy
3 жыл бұрын
Try on already opened browser. It is explained in below tutorial: kzitem.info/news/bejne/0qmLxW2Bj5OKgoo
@harish6268
3 жыл бұрын
When I'm tricking to click option in getelementsbyclassname it's throwing error.... Is there any other option
@AutomationMadeEasy
3 жыл бұрын
share ur code.
@MohantyTapas
4 жыл бұрын
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.
@AutomationMadeEasy
4 жыл бұрын
need to see the web page
@ednedn2326
3 жыл бұрын
Any special reason for using the "without id's " approach?
@AutomationMadeEasy
3 жыл бұрын
many elements may not have id's. so these techniques come in handy
@ednedn2326
3 жыл бұрын
@@AutomationMadeEasy Thanks a lot!
@keerthikeerthi581
2 жыл бұрын
@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.
@AutomationMadeEasy
2 жыл бұрын
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
@keerthikeerthi581
2 жыл бұрын
@@AutomationMadeEasy thank you for quick reply I will try this 😃
@keerthikeerthi581
2 жыл бұрын
@@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
2 жыл бұрын
obj.close
@keerthikeerthi581
2 жыл бұрын
@@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
@tpdakc7904
4 жыл бұрын
why error doc.Document ???
@AutomationMadeEasy
4 жыл бұрын
didnt get you. Please explain the issue in detail
@luismartinez8337
4 жыл бұрын
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
@AutomationMadeEasy
4 жыл бұрын
Try alternate approch explained in below tutorial: kzitem.info/news/bejne/onumlo2boqVqdII
@ravisankar1974
4 жыл бұрын
Hello Automation made easy.i need you help could you please help me how can i contact you?
@syedshafiulla3093
4 жыл бұрын
Bro when using ie, if there is no name, id, class how to select webelement
@AutomationMadeEasy
4 жыл бұрын
there shall be somethig in the html to identify it.
@travllingisfun6189
4 жыл бұрын
HI, Can we automate firefox using vba.
@AutomationMadeEasy
4 жыл бұрын
not Firefox but you can automate edge and chrome. Refer below tutorial: kzitem.info/news/bejne/onumlo2boqVqdII
@travllingisfun6189
4 жыл бұрын
@@AutomationMadeEasy Thanks.
@luismartinez8337
4 жыл бұрын
Hi, how i find number's class name or name if the page is so big?
@AutomationMadeEasy
4 жыл бұрын
Numbering is sequential left to right top to bottom
@gajananp83
3 жыл бұрын
This is helpful ... Thank you .. I am facing some issues and details mail to you, please check and suggest.
Hi sir, Am getting on error while automating on web app .error 91.. Object variable or with block not set
@AutomationMadeEasy
4 жыл бұрын
share ur code
@angelzworld5007
4 жыл бұрын
@@AutomationMadeEasy how to contact you
@AutomationMadeEasy
4 жыл бұрын
share ur contact info I will get in touch or write into info@automationandagile.com
@mkv7595
4 жыл бұрын
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
Пікірлер: 99