Hi, I need help in automating mobile app testing via excel. Requirement is as below: 1) I want to launch browserstack web app via excel. 2) login to browserstack via user id /password available in excel cell. 3) launching Android mobile device in browserstack 4) login to mobile app using credentials input in excel cells. 5) Selecting payment transfer option 6)Input test data from excel to mobile app like Benifeciary name ,amount etc 7) Accepting T&C check box and Clicking on pay button to push payment. Each step should be captured/recorded for evidence purpose. Is it feasible to do from excel macros?? If so then please help
Hi, I have an excel file with almost 5000 columns/rows of data.. I wanted to make it a web app so that the team member can add specific info using the web-based app and store the data in the same excel... please let me know how can I achieve this?
Thanks Vasu. Below are the links to similar tutorials I have recently uploaded . These may be of your interest. th-cam.com/video/vnIsNa4de7M/w-d-xo.html th-cam.com/video/T6HRjiAdW38/w-d-xo.html Do subscribe to my channel for latest tutorials. Thanks & Regards
My vba works to fill the online first page, from the data in excel... But when it clicks on submit, a new page loads and which requires more data to be filled in continuation of first page information...My issue is how to keep the page active So that it keeps on getting the data from the excel sheet... In continuation... Kindly suggest.. No selinum will be used, only vbs
For example, my spreadsheet contains a list of many businesses. I want to search for each business within each businesses different State government websites. Ideally, an automated excel vba solution to perhaps go to that State url AND from there paste in the business name + click a search button.
hi I have been looking for such a tutorial for long. luckily i got it in recommendation. Can we automate a form filling process like for example where i have to do some clicks, enter data.,scroll down for date or other options like institute name etc, go to next page and then download file in the end it will be a great help.
Hello sir, This video is very informative. I am currently working on same kind of task for one of my office automation work. Just need your help in getting the code to activate the second pop up window like @15:44 and clicking on that link. I'd be grateful for your help. Thanks in advance.
Sir thanks for the video keep it up I have one request if web page data is automatically updated after 1 min time interval how do we automatically extract that data nd save or keep with respect to time
Hi Sir, When i enter values ,it is showing as entered ,but when i click on submit button,values are gone and getting error as 'Please enter the value'..Please help with this situation.
Well my friend the playlist has everything you may need to know about excel web automation.Below our couple of video tutorials which may interest you: th-cam.com/video/docnLSdj8rI/w-d-xo.html th-cam.com/video/T6HRjiAdW38/w-d-xo.html
So helpful. Thank you for taking the time to create.
Thanks.you may be interested to look into edge browser. Refer below tutorial:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
Great, very informative...thanks..
Glad it was helpful!
Thanks much for the info.
your welcome
Hi, I want to know all methods available to control the web browser. Where i can find these methods?
Hi,
I need help in automating mobile app testing via excel.
Requirement is as below:
1) I want to launch browserstack web app via excel.
2) login to browserstack via user id /password available in excel cell.
3) launching Android mobile device in browserstack
4) login to mobile app using credentials input in excel cells.
5) Selecting payment transfer option
6)Input test data from excel to mobile app like Benifeciary name ,amount etc
7) Accepting T&C check box and Clicking on pay button to push payment.
Each step should be captured/recorded for evidence purpose.
Is it feasible to do from excel macros?? If so then please help
Hi, I have an excel file with almost 5000 columns/rows of data.. I wanted to make it a web app so that the team member can add specific info using the web-based app and store the data in the same excel... please let me know how can I achieve this?
Hi Ashu, super video, i am waiting for this since 5 years. plz upload more videos.
Thanks Vasu. Below are the links to similar tutorials I have recently uploaded . These may be of your interest.
th-cam.com/video/vnIsNa4de7M/w-d-xo.html
th-cam.com/video/T6HRjiAdW38/w-d-xo.html
Do subscribe to my channel for latest tutorials.
Thanks & Regards
Thanks Ashu for your quick reply.
My vba works to fill the online first page, from the data in excel... But when it clicks on submit, a new page loads and which requires more data to be filled in continuation of first page information...My issue is how to keep the page active
So that it keeps on getting the data from the excel sheet... In continuation... Kindly suggest.. No selinum will be used, only vbs
What if a dropdown element does not have and ID? I have tried class classname span class.
Very helpful, thank you! Question, how might you set that webpage to be a variable that's grabbed from an Excel cell?
By web page you mean the url of the page?
Can you please give an example so I understand your requirement and provide a solution.
For example, my spreadsheet contains a list of many businesses. I want to search for each business within each businesses different State government websites. Ideally, an automated excel vba solution to perhaps go to that State url AND from there paste in the business name + click a search button.
Ok understood. Do you mind sharing your email id. I will send out the excel template for your requirement.
That would be great, thanks! rrehelmig@gmail.com
Sent you an email. Please check.
Nowadays we are using edge instead of IE so plz clear this topic. How should we open web application
yes, refer below tutorial:
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
Hi
When I m creating ie as object it shows runtime error 429
Activex component can't creat object
hi
I have been looking for such a tutorial for long. luckily i got it in recommendation. Can we automate a form filling process like for example where i have to do some clicks, enter data.,scroll down for date or other options like institute name etc, go to next page and then download file in the end it will be a great help.
yes absolutely. refer below tutorial
th-cam.com/video/docnLSdj8rI/w-d-xo.html
If I wanted to select a different option in the drop down next to the login button, is this possible to do? Thanks!!
Yes it is possible, Refer below tutorial:
th-cam.com/video/T6HRjiAdW38/w-d-xo.html
Can i program this for one website and than use it also for other websites with the same questions ?
no
@@AutomationMadeEasy Thank you for your response
can I use it for a form that goes over several sides and requires to press next ?
Absolutely
Hello sir,
This video is very informative. I am currently working on same kind of task for one of my office automation work. Just need your help in getting the code to activate the second pop up window like @15:44 and clicking on that link.
I'd be grateful for your help.
Thanks in advance.
Can tell how to enter data from excel to web form please .So that we can application of each students online .
refer below tutorials:
th-cam.com/video/docnLSdj8rI/w-d-xo.html
th-cam.com/video/AEp0Yeis9AM/w-d-xo.html
Sir thanks for the video keep it up
I have one request if web page data is automatically updated after 1 min time interval how do we automatically extract that data nd save or keep with respect to time
refer below tutorial:
th-cam.com/video/docnLSdj8rI/w-d-xo.html
nice one
Thanks
Can I use chrome instead of IE
Refer below video:
th-cam.com/video/-GUw22ecRwI/w-d-xo.html
Hi Sir, When i enter values ,it is showing as entered ,but when i click on submit button,values are gone and getting error as 'Please enter the value'..Please help with this situation.
Try below alternate approach:
th-cam.com/video/-GUw22ecRwI/w-d-xo.html
friend
you have just shown us the coding . but not shown us the working eithe prior or post video
Well my friend the playlist has everything you may need to know about excel web automation.Below our couple of video tutorials which may interest you:
th-cam.com/video/docnLSdj8rI/w-d-xo.html
th-cam.com/video/T6HRjiAdW38/w-d-xo.html
HELLO SIR,
I DONT GET 'ID' BUT INSTEAD I GET ONLY 'CLASS' AND 'TYPE' .
HERE" Get Itinerary "
WHAT SHOULD I DO?
doc.getElementsByClassName("btn btn-primary block bold ig-search-btn get-itinerary-button")(0).click
THANK YOU SO MUCH. IT WORKED@@AutomationMadeEasy
WHAT IF THERE IS NO ID?
@@AutomationMadeEasy
doc.getElementsByClassName("umb-home-web-check-input1 managepnr")(0).click
its showing compile error please help
Please provide error message