How to Automate Web Application using Excel

In this tutorial we would learn how to automate web applications using excel macros

[HotButteredCorn]

So helpful. Thank you for taking the time to create.

[tejaslabhashetwar]

Hi, I want to know all methods available to control the web browser. Where i can find these methods?

[vasuien]

Hi Ashu, super video, i am waiting for this since 5 years. plz upload more videos.

[rajkannar]

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?

[youknowme]

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

[puneeth.suvarna]

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.

[ScamHunter-su]

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

[rickhelmig]

Very helpful, thank you! Question, how might you set that webpage to be a variable that's grabbed from an Excel cell?

[yogeshsharma]

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.

[steveholcombe]

What if a dropdown element does not have and ID? I have tried class classname span class.

[s.t]

Can i program this for one website and than use it also for other websites with the same questions ?

[Yatender_Yatender]

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

[Sheik]

Can tell how to enter data from excel to web form please .So that we can application of each students online .

[csgardner]

If I wanted to select a different option in the drop down next to the login button, is this possible to do? Thanks!!

[dharmendrasinghchauhan]

Hi
When I m creating ie as object it shows runtime error 429
Activex component can't creat object

[DeepakSoni-nxzy]

Nowadays we are using edge instead of IE so plz clear this topic. How should we open web application

[JessakuttyAndJochu]

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.

[baramullatravels]

HELLO SIR,
I DONT GET 'ID' BUT INSTEAD I GET ONLY 'CLASS' AND 'TYPE' .
HERE" <button class="btn btn-primary block bold ig-search-btn get-itinerary-button" type="button">Get Itinerary</button> "
WHAT SHOULD I DO?

[romilkulshreshtha]

friend
you have just shown us the coding . but not shown us the working eithe prior or post video