Automate Internet Explorer with Excel VBA Part 3- Automatic web form filling

Title: Automate the webform filling or data entry work from Internet Explorer using Excel VBA

Recommended Excel VBA books
===================================================
====================================================

In this video, you'll learn how to

======================================================
1)How to launch internet explorer with Excel VBA
2)How to navigate to webpage using VBA
3)Wait until the browser gets loaded
4)How to identify the webelement to automate the form filling work
5)How to locate weblement and create object for webelement in VBA
6)How to pass value or text to webelement textbox in VBA
7)How to handle dropdown in webpage using excel VBA
8)How to submit the web form from VBA

======================================================

[tirushma]

This Is what make us believe in Web Tutorial!!!!...cARtloads of thanks respect and gratitude

[sachinsingh-hzdr]

Really very useful tutorial... Thanks and great job

[sushilchaudhari]

Worth to watch!!! Thanks for sharing such a nice tutorials

[gazidawan]

Thank you sir, Amarindaz for Nice Tutorial.

[CSVspb]

Thank you for this video. I had one problem, but i saw decision in this video=)

[mahimanasa]

Hi Amarindaz, it s a good tutorial.
Based on this video I can pick the data from the excel sheet by giving the cell reference.

i would like to use this for the data entry from excel to webpage form. I can do the one form.submit in one time.
But how to repeat the process for 100rows in one go. Just like a data loader

[manoramadey]

Finally I found something what I need .. Tx

[xaospayne]

Firstly thanks for this video tutorial. just have 3 question regarding the the video
1. Is there a way to ensure the window which contains the website Url opens in a full screen(maximize window) rather than a normal window.
2. It gets really annoying to keep hitting the play to execute the code automatically. Can we create a command button on the excel sheet to execute the run button from the sheet itself?
3. apart from the get element by id what are the other methods to get the info from a website.. like texts or hyperlinks ?

Once again thanks for this kickass video ;) !!!
Cheers.

[hemanthmaharana]

Hi Amarind Thanks so much for making this video. I have one query about in internet explorer how write code for "clicking" any option in web page...

[cenationrko]

what if i dont want to open new window each time i run the macro, i just want to fill data in already opened window please help awesome video

[kamalakotagiri]

Vba query: Can we choose a file to upload by clicking on browse button which is in webpage. If yes can you please help me?

[manuelruthardt]

Hi, thank you for the video. I really like these kind of tutorials. I tried to run your code myself but at the line:

"Set fname =

I get the following Error:
Run-time error '13': Type mismatch

I cannot figure out why. This for example works = "TestValue" but I would like to understand why yours doesnt seem to work for me.

If anyone has an Idea let me know.

[arunvikramn]

Nice video... I have a captcha image in login screen.. how can I bypass it.. the data entry page is available only after login with proper credentials.. any way around???

[md.shamim]

I use a Excel data file which carry 100 rows and 16 columns, There the Mother's name, the Father's name e.t.c and a Picture. When my data Automatically Fill a web from using VBA coding, I want to know how to add Automatically the picture in the from. what is the code??? Help me please

[CalmBeans]

What references need to be active for this subroutine to work. So far I have enabled "Micorsoft Internet Controls" but I am still getting a "Run-time error '13': Type mismatch" when the subroutine reaches "Set fname =
fname.Value = "First Name""Any ideas?

[Zainab_]

Hi, I have tried and tested to unlock an excel workbook which is password protected by my ex colleague but I have failed multiple times. I saw your video on how to unlock VBA Project and Macro code but it did not help either after reaching the VBproject.bin I do not get an option of "Open with" so cannot move to the next step. I tried to open the file direct from HEX editor but was not able to do so...

Can you help me as its our quality grading sheet and i need to unlock the password to make changes on the sheet

Can u give ur email ID to communicate further?

[amitbodhwani]

Hi,
There is a text box on my webpage which on clicking will pop up a calendar the properties of that text box is

<input name="date" class="hasDatepicker" id="datepicker" style="width: 120px; height: 30px;" type="text">

I tried clicking that button using and and also but i failed everytime and i am not able to click text box because of which the calendar on my webpage is not appearing.
I tried using Selenium Java code and it is working fine with it but i want to code with VBA scripting.
Please help me with this issue as while running i am not getting any errors also.
Thank You

[himanshukumarsingh]

Hi Amarindaz, as i told you about my problem on your other post just now, i will explain that problem now- in the above video while filling dropdown of country you have given diff.code as compared to others. So, the form which i want to fill has more tha 2 drop downs. If i am selecting X in dropdown 1 then i have diff. options in dropdoown 2 like X1, X2, X3, etc.
So i am able to fill the first dropdown but not able to fill the 2nd dropdown. What should i do now, any solution for this??

[NicoTorDev]

thanks for the video, but is there any way I can put some data that I want and then refresh the page and put other different data and so all the time?

[chennaicoffee]

how to select / click the radio button in web page using vba code? for example yes or no !!! Can you help me out ?