How to Automate Data Entry in a web form using excel macros

Share
Embed
  • Published on Jun 11, 2018
  • In this tutorial we would learn:
    1. How to automate data entry in a web form
    2. How to fetch data from excel file and populate a web form/page

Comments • 243

  • Eric Flaherty
    Eric Flaherty 8 days ago

    I have a few hundred of the same form to fill out and was hoping to pull info from a spread sheet as you instructed. There is no direct link to the form page as it seems to have some sort of protection nor does it show the element Id in the html code. Any suggestions.

    • Automation Made Easy
      Automation Made Easy  7 days ago +1

      doc.getElementsByName("roof-last-name")(0).Value = "test1234"

      With above code you would be able to identify the web element without having id's

    • Eric Flaherty
      Eric Flaherty 7 days ago

      This is all it shows. I went as fas as adding the selenium object finder to google chrome and nothing shows up on the hover over.

  • Manish Bidarkar
    Manish Bidarkar 10 days ago

    Hello Sir, Very Good and Well explained. I want to create similar macro just want add one thing. I would like to upload a file from my pc to web. How could we do that ?

    • Automation Made Easy
      Automation Made Easy  10 days ago

      File upload dialogue is not a web object and hence it cannot be seamlessly automated without support of third part softwares.

  • Madan Raj
    Madan Raj 12 days ago

    Initially thanks a lot for giving up a free training ,I have been trying very hard on this it's not getting inputted of username and password ,would request to help me out would be very thankful in all way please"portal.dtcc.com"

    • Automation Made Easy
      Automation Made Easy  5 days ago

      I tried the same code and it works well. Below tutorial demonstrates an alternate way to automate. Try this approaach
      ru-clip.net/video/-GUw22ecRwI/video.html

    • Madan Raj
      Madan Raj 5 days ago

      Hi that is still not entering username and password ,it lands me in the page ,but does not input the username and password ,any help to resolve this

    • Automation Made Easy
      Automation Made Easy  12 days ago +1

      Your welcome. Use below lines of code:

      doc.getElementsByName("username")(0).innerText = "test"
      doc.getElementsByName("password")(0).innerText = "test1234"

  • Mueez Inc.
    Mueez Inc. 15 days ago

    Hello Sir, very grateful for making such informative and useful videos.
    Please help me out with this issue:
    I have to select a dropdown value by picking from excel. Then the next dropdown will be populated based on the previous selection and so on. However, the issue am facing is that the 3 dropdown boxes whichbare there in the webpage are populated with some values. The next dropdown changes only when I click the dropdown option and not when I select using its value

    • Automation Made Easy
      Automation Made Easy  13 days ago

      i understood your requirement but to understand the dynamics of html I need to actually analyze the webpage

    • Mueez Inc.
      Mueez Inc. 14 days ago

      +Automation Made Easy The dropdown values by default are LEName, LEBranch.
      There are a lot of options in the dropdown for LEName but LEBranch dropdown contains only 1 value. However when a particular LEName is selected by clicking, LEBranch is populated with respective Branch names.
      When I try selecting the dropdown values from excel by giving the id, the LEBranch gets filled with the only value because that's the only one which is present there.
      I need to select the LEName drop down, then wait for sometime to load values in the LEBranch dropdown, then fill the values from excel by id in the webpage.
      Hope this helps in understanding the problem

    • Automation Made Easy
      Automation Made Easy  14 days ago

      need to see the web page to suggest a solution.

  • dileep karna
    dileep karna 20 days ago

    Hello Sir.. Please reply

  • Sunil B Patel
    Sunil B Patel 22 days ago

    i want to my excel sheet data fill in website step by step rows and column data....please help me

  • selvakumar v
    selvakumar v 23 days ago

    Good video!!!!!
    Your explanation is awesome..

    • selvakumar v
      selvakumar v 14 days ago

      I have the image of that coding... Could you please provide your mail id... Then i can easily share....

    • Automation Made Easy
      Automation Made Easy  20 days ago

      Share the html of the element and the code on which you are getting error.

    • selvakumar v
      selvakumar v 20 days ago

      Thank you so much sir....
      But again i got an error in doc. getElementById() in the line... It's showing as objects doesn't support this property.... Please help me.....

    • Automation Made Easy
      Automation Made Easy  20 days ago

      Use below lines of code for invoking IE browser.

      Dim IE As InternetExplorerMedium
      Set IE = New InternetExplorerMedium
      IE.navigate "example.com"

    • selvakumar v
      selvakumar v 21 day ago

      Yes....

  • dileep karna
    dileep karna 26 days ago

    i have some query in macro writing.. can i get your details to contact ?

  • Sathish Kumar
    Sathish Kumar 27 days ago

    How to run this macro for sub menu link. Home - > Register Form ? How to open a webpage and navigate to specific menu.Any idea

    • Automation Made Easy
      Automation Made Easy  27 days ago

      Its possible , depends on how html is structured. you can share html of the page, will look into it.

  • Prashant kumar
    Prashant kumar Month ago

    I am getting an compile error "Procedure too long" can you help me please

  • bala saravanan
    bala saravanan Month ago

    Br can you send me code

  • Mr. TwiTched
    Mr. TwiTched Month ago

    Great video bro. But how can we do this from external .XLSX file

    • Mr. TwiTched
      Mr. TwiTched Month ago

      +Automation Made EasyJust think You want to fill the Web form but this time all data like Firstname, last name, email etc is stored in another excel document, say "C:\doc.xlsx" so how can we do this now. Is there anyway.

    • Automation Made Easy
      Automation Made Easy  Month ago

      Thanks. I didnt get your question. Can you please elaborate

  • Patel Rahul
    Patel Rahul Month ago

    Sir can you plz make video how to get nseindia.com data into ms access automatically if you help me I will very thankful

  • pooja baluja
    pooja baluja Month ago

    Hi, can i put a button on excel sheet to execute the code? Also I want to fill the form one row at a time, not in a looped manner for i would be updating the excel sheet for every new entry, is it possible to get the data from the current row without having to modify the code?
    also can I use any other web browser like chrome or firefox?

    • Automation Made Easy
      Automation Made Easy  Month ago

      Yes you can put a button and best way to execute the data of each row would be a loop, but if you do not want to use a loop you use the same row Index. Refer below video for solutions to the above mentioned points
      ru-clip.net/video/vnIsNa4de7Mh/video.htmlttps://ru-clip.net/video/vnIsNa4de7M/video.html

      For execution on chrome browser refer below video:
      ru-clip.net/video/-GUw22ecRwI/video.html

  • karpelitgroup
    karpelitgroup Month ago

    Great instructional video. I subscribed. At the end you mention another video where you describe using "for loops" to transfer multiple lines of data from an excel sheet to a web form. Can you provide a link? Thanks.

    • Automation Made Easy
      Automation Made Easy  Month ago

      Thanks. Below is the link of the video you requested:
      ru-clip.net/video/vnIsNa4de7M/video.html

  • Hitesh Kanojia
    Hitesh Kanojia Month ago

    This is one of the far most beautifully explained video on macros for Data Entry....keep up the good work buddy.....

  • betacarotinoid
    betacarotinoid Month ago

    How can you add an interval before every input?
    Great vid btw

    • Automation Made Easy
      Automation Made Easy  Month ago

      Thanks. You can use the below line of code:
      Application.Wait DateAdd("s", 1, Now)

  • UBAID POOKOTTUR
    UBAID POOKOTTUR 2 months ago

    Very useful video for me

  • Ahmed Ismail
    Ahmed Ismail 2 months ago

    Hi, am new to VBA , but i have a problem , i have a work in EXCEL from 20 columns and thousands of rows, to enter all data in a cloud page, the page is numbered and use td , and tr a button next the table will take you to this page to add in, so each are different and href so i wonder , how to make a loop to
    1- open the page
    2- click the correct href edit button
    3- start editing from the selected raw
    4-submit and wait for the table page to open and then search for the next one tr number and go to one
    5- until it finished or didn’t find a number
    never find things like this all over

    • Automation Made Easy
      Automation Made Easy  2 months ago

      I need to see the web page. Can you share the link?.You can email me at automationandagile@gmail.com

  • Alan Lewis
    Alan Lewis 2 months ago +2

    Brilliant videos- I love them

    in the video above _ have got everything working but when I click on the submit button all the data from the elements disappears- can you assist at all?

    • Muhammad Ahmed
      Muhammad Ahmed 9 days ago

      +Automation Made Easy - Can you please send me the code for the above as well ?

    • Automation Made Easy
      Automation Made Easy  2 months ago

      I sent you the solution on your email

  • Nikhil Nikki
    Nikhil Nikki 2 months ago

    Auto captcha enter do on video about this..

  • Alan Lewis
    Alan Lewis 2 months ago

    Nice work- how about the "Submit button" what is the element for that?

    • Alan Lewis
      Alan Lewis 2 months ago

      Thanks you answered this in an earlier post! many thanks

  • SM world
    SM world 2 months ago

    Pls make new vedio ,using looping for multipleExcel data autofilup

  • Scott Jarousky
    Scott Jarousky 2 months ago +1

    What about looping through multiple rows of excel data to input into an IE site?

  • LyF with Ss
    LyF with Ss 2 months ago

    Awesome.........

  • sbp plus
    sbp plus 2 months ago

    i need help

  • dheerendra prajapati
    dheerendra prajapati 2 months ago

    I had tried to auto-populate the drop-down menu using your method doc.getElementById("ctl00_Contentplacemain1_ddlFacility").Value = CDC P where my ID is ctl00_Contentplacemain1_ddlFacility but not sure why it is not working. Please find below the full scenario of the drop-down menu.


    name="ctl00$Contentplacemain1$ddlFacility" onchange="javascript:setTimeout('__doPostBack(\'ctl00$Contentplacemain1$ddlFacility\',\'\')', 0)" id="ctl00_Contentplacemain1_ddlFacility" class="selectDrop">
    -Select-
    BANG 1
    BANG 10
    BANG 10i
    BANG 10t
    BANG 11
    BANG 12
    BANG 2
    BANG 3
    BANG 4
    BANG 4i
    BANG 4S
    BANG 5
    BANG 6
    BANG 6i
    BANG 7
    BANG 8
    BANG 9
    BANG 9i
    CDC 1
    CDC 3
    CDC 4
    CDC 5
    CDC P
    DDC 1
    DDC 1i
    DDC 2
    DDC 3
    DDC 4
    DDC 4i
    DDC 5
    DDC 5i
    DDC 6
    DDC 6i
    DMC1A
    GTIN
    HDC 1
    HDC 2
    HDC 2i
    HDC 3
    HDC 4
    HDC 4i
    HDC 5
    HDC 5i
    HDC 6
    KDC 1
    MC 1
    MDC 1
    MDC 2
    MDC 3
    MDC 4
    MDC 5
    MDC 6A
    MDC 7
    PDC 1
    PDC 2
    PDC 3
    PDC 4
    PDC 5

  • strjfs
    strjfs 2 months ago

    This video has been very helpful. I'm now writing VBA code in Microsoft Access to automate web form data entry. I prefer Access because of the advanced forms you can build in it and because it is better at storing, querying and transforming data. I'm discovering that some functions and objects are not available in Access that are available in Excel. For example, I need to simulate key presses such as pressing the Enter key on a web page. Excel has the Sendkeys object, but Access does not have it (unless I'm missing a reference). Application.Wait does not work in Access. I wrote a custom Sub to make the code wait for pages to load:
    Sub Wait(seconds As Integer)
    Dim waitTime as Date
    waitTime = DateAdd("s", seconds, Now)
    Do
    'Wait
    Loop Until Now >= waitTime
    End Sub
    I can click on things with Access VBA, but it does not have Sendkeys to simulate key presses. Do you know if there is a way to simulate key presses on web pages using Access VBA?

    • Automation Made Easy
      Automation Made Easy  2 months ago

      You can use access as a database and write your code in excel vba. It is possible to connect to access db using excel vba. If you use this approach you would get the benefit of data storage in access db as well as excel vba advantages.

  • strjfs
    strjfs 2 months ago

    Can you automate logging in to a site that has Captcha or other bot-blocking checks? Or can you have the script access a browser and site that you have logged in to manually?

    • Automation Made Easy
      Automation Made Easy  2 months ago

      Captchas cannot be handled. Below is the code snippet which could be used to connect to already opened browser window:

      Sub test1()
      On Error Resume Next
      Set objShell = CreateObject("Shell.Application")
      IE_count = objShell.Windows.Count
      For x = 0 To (IE_count - 1)

      url = objShell.Windows(x).Document.Location
      title = objShell.Windows(x).Document.Title
      If InStr(1, url,"your url") > 0 Then
      Set ie = objShell.Windows(x)
      Exit For
      Else
      End If
      Next
      End Sub

  • Debiprakash Chhuria
    Debiprakash Chhuria 3 months ago +2

    Very very helpful thank, requesting for multiple row sir

  • Random idea
    Random idea 3 months ago

    nice way and very simplifed.... thanks

  • Erica Adams
    Erica Adams 3 months ago

    I get a run time error 91 object not set or blocked for get element by Id (“ “). Click

    • Automation Made Easy
      Automation Made Easy  3 months ago

      The site is not opening. You can email me on easilyautomateashu@gmail.com with specific queries.

    • Erica Adams
      Erica Adams 3 months ago

      Automation Made Easy Sure see below, some data left blank on purpose. The Click is where I get the error message, IE launches and the user credentials work, it’s the next page of clicks on a radio dial that I have issues with.
      Dim IE As Object
      Dim doc As HTMLDocument
      'Dim Elements As IHTMLElementCollection
      'Dim Element As IHTMLElement

      Set IE = CreateObject("InternetExplorer.Application")
      IE.Visible = True
      IE.Navigate "test.com/QRLogOn.aspx?ReturnUrl=%2fQRMain.aspx%3f%26app%3dcitizens&&app=test"
      Do While IE.Busy
      Application.Wait DateAdd("s", 1, Now)
      Loop
      Set doc = IE.Document
      'IE.document.getElementById("txtUserId").Value = ""
      doc.getElementById("txtUserId").Value = ""
      doc.getElementById("txtPassword").Value = ""
      doc.getElementById("btnLogOn").Click
      doc.getElementById("rbRecurringSchedule").Click

    • Automation Made Easy
      Automation Made Easy  3 months ago

      Is your doc object correctly initialized. If you can paste the code up to the line which is giving you error, It would be easier for me to decode it.

  • Martin Rajith
    Martin Rajith 3 months ago

    How to extract data from PDF using vba

  • Martin Rajith
    Martin Rajith 4 months ago

    Can you help me to automate data entry in autocomplete field using vba

  • Pankaj Lakra
    Pankaj Lakra 4 months ago

    Plz give a your contact no

  • Vito Felicciardi
    Vito Felicciardi 4 months ago

    Is it possible for me to voice command on my iPhone xs to have my computer open a specific form that I use all the time, dictate the message I want to e added to that form in a particular place, then have it emailed out??

  • Khushi Gaur
    Khushi Gaur 4 months ago

    How to use loop function if i have n number of data in excel. Also how to use web automation for the Next page which shows after submit..
    A great video so far...waiting for some more

    • Khushi Gaur
      Khushi Gaur 4 months ago

      Im able to go to firstpage n when click on submit, a new page load, and here is the issue as it dont select or consider the IDs...kindly suggest....or email

    • Automation Made Easy
      Automation Made Easy  4 months ago

      Thank you. Below videos should answer your queries.
      ru-clip.net/video/-GUw22ecRwI/video.html
      ru-clip.net/video/vnIsNa4de7M/video.html

  • Market Mahabharat
    Market Mahabharat 4 months ago

    I mailed you please reply.
    Thank you

  • Jossi Ossa
    Jossi Ossa 4 months ago

    Dear sir, do you have also video how to automate data entry on local html file? So i mean not online, i have html file with js on my desktop to make my calculations... Thank you to read this!

    • Automation Made Easy
      Automation Made Easy  3 months ago

      Your welcome. Happy to help :)

    • Jossi Ossa
      Jossi Ossa 3 months ago

      +Automation Made Easy Thank you very much! You helped me alot

    • Automation Made Easy
      Automation Made Easy  4 months ago

      Provide the path of your html file as given below:
      ie.Navigate "path of your html file with extension"

  • Jossi Ossa
    Jossi Ossa 4 months ago

    Thank you very much! Very good teacher!!!
    And how can i fill this 2 :


    Do you think sir it is posible?

  • cenAtion Rko
    cenAtion Rko 4 months ago

    dear brother i want to fill a online form could you please make a script for me i can pay you for that i have mailed you for the same check your hangouts please

    • Automation Made Easy
      Automation Made Easy  4 months ago

      I replied to your email. Please check your inbox. We willl take it forward from there.

  • Paul Moffatt
    Paul Moffatt 5 months ago

    Very helpful, thank you!

  • triarev sarl
    triarev sarl 5 months ago

    Great video, thank you
    how to submit the data entry after filling, if there's a submit button

  • Shindudayan
    Shindudayan 5 months ago

    Thanks for your video and it was really helpful. Could you please help me to develop a scrip for Chrome instead IE. Please reply. Thanks in advance

  • GCowner
    GCowner 5 months ago

    What if web page is already open and I just want to fill that specific form out?

    • Automation Made Easy
      Automation Made Easy  5 months ago

      Use below code snippet. Let me know if you have any questions

      Set objShell = CreateObject("Shell.Application")
      IE_count = objShell.Windows.Count
      For X = 0 To (IE_count - 1)
      On Error Resume Next
      my_url = objShell.Windows(X).document.Location
      my_title = objShell.Windows(X).document.Title
      If InStr(1, my_title, "ur desire page title") > 0 Then
      Set ie = objShell.Windows(X)
      Exit For
      Else
      End If
      Next
      ie.document.getElementById("your field").Value = "test"

  • Sidharth Pattanayak
    Sidharth Pattanayak 5 months ago

    sir please check your e-mail and kindly provide the solution......

  • Sidharth Pattanayak
    Sidharth Pattanayak 5 months ago

    doc.getElementById("ContentPlaceHolderMain_DDLUsertype").Value = "2"
    after executing this code next combobox (which is dependent to first combobox) is not displaying

  • Candy Tok
    Candy Tok 5 months ago

    please send me a link to a video showing how to do bulk entries from excel

    • Automation Made Easy
      Automation Made Easy  5 months ago

      ru-clip.net/video/vnIsNa4de7M/video.html

      Let me know if you have any questions.

  • Adam Klein
    Adam Klein 5 months ago

    I’m stuck with angular JS links, how do we find the relevant web elements for use with the VB template ?

    • Automation Made Easy
      Automation Made Easy  5 months ago

      Sure please email me at easilyautomateashu@gmail.com

    • Adam Klein
      Adam Klein 5 months ago

      I’ve taken screenshots etc

    • Adam Klein
      Adam Klein 5 months ago

      It’s pretty complicated. Its a password protected site (work) that I’m trying to automate, I don’t even know if it’s possible to do. Can I email you for advice or for your services?

    • Automation Made Easy
      Automation Made Easy  5 months ago +1

      Can you share url of the page. I will create the solution and revert.

  • gabr mohamed
    gabr mohamed 5 months ago

    Thanks for the wonderful video its really great and very easy to understand and follow, I have a question what about if i want to input file location in a browse button to upload without initiating the browse file dialogue just input the file location

    • Automation Made Easy
      Automation Made Easy  5 months ago

      Try using doc.getElementByID(" id of the element").innerText = "File Path"

  • Sidharth Pattanayak
    Sidharth Pattanayak 5 months ago

    How I handle these comboboxes (present inside the site)
    extensionreforms.dacnet.nic.in/LoginTest.aspx

    • Automation Made Easy
      Automation Made Easy  5 months ago

      doc.getElementByID(" id of the element").Value= 2 ( I have given value=2 just for example. Look for the value attribute in the HTML of the dropdown options)

  • Sidharth Pattanayak
    Sidharth Pattanayak 5 months ago

    Very good video sir
    How I use Microsoft Edge for automation. What is the VBA code for call Microsoft edge instead of internet explorer

    • Sidharth Pattanayak
      Sidharth Pattanayak 5 months ago

      Thank you Sir

    • Automation Made Easy
      Automation Made Easy  5 months ago +1

      VBA uses COM model which is not supported Edge browser. On Windows 10 both IE and Edge browsers are available. For VBA use IE11.

  • Richard Ford
    Richard Ford 5 months ago

    Hi, great video.
    I’m trying to paste into input forms within table rows that all have unique id’s. Is there a way to do this? Thanks

    • Automation Made Easy
      Automation Made Easy  5 months ago

      Please share the url of your web page. I will look into it and revert.

  • Dream Tech Solution
    Dream Tech Solution 5 months ago

    hi can you share this codes

  • Kashif Sheikh
    Kashif Sheikh 6 months ago

    Hi Mate, I'm running your code. Unfortunately I'm getting '438' error message. What am I doing wrong?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      At what line are you getting the error. Paste your code in the comment section. I will look into it and revert.

  • Quanbowu
    Quanbowu 6 months ago

    Hi Ashu, I ran into the error Method 'Document' of object 'IWebBrowser2' failed, could you please help me on this? Thanks

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Replace line Dim IE As Object with Dim IE As InternetExplorerMedium and
      Set IE = CreateObject("InternetExplorer.Application") with Set IE = New InternetExplorerMedium

  • Jake Delger
    Jake Delger 6 months ago

    How would I add the code to press the login button after filling the form?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Yup, received it and replied.

    • Jake Delger
      Jake Delger 6 months ago

      Email sent

    • Automation Made Easy
      Automation Made Easy  6 months ago

      You have to use the button object an use click method. If your problem is specific to your web page, email me with your problem details on easilyautomateashu@gmail.com. I would be happy to help.

  • LL
    LL 6 months ago

    how about if i want to populate the data from the excel to the web form many times? and dont have to quit the application?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      I have sent you the solution.

    • LL
      LL 6 months ago

      +Automation Made Easy i have emailed you

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Yes. Email me your url (easilyautomateashu@gmail.com). I will reply with an example.

    • LL
      LL 6 months ago

      +Automation Made Easy what if the html not show any id? the textbox is just show placeholder & name. but no id. is it possible to do it?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Refer the video in below link:
      ru-clip.net/video/vnIsNa4de7M/video.html

  • Bbb 234
    Bbb 234 6 months ago

    I need a help...Can you help me?

  • Vinod Godhasara
    Vinod Godhasara 6 months ago +1

    I want to create autofill form from excel but web is required first Login and after fill up form how do

    • Hamim Rahman
      Hamim Rahman 3 months ago

      Thank you so much brother

    • Automation Made Easy
      Automation Made Easy  3 months ago +1

      Browser will close automatically when the macro ends. You can use the msgbox trick to make it wait until you click the message box.

    • Hamim Rahman
      Hamim Rahman 3 months ago

      +Automation Made Easy Brother thank you soo much for this help! now my project is working but it's need to one little thing! that is i have to stay on this page but it by itself automatically closed the chrome tab!

    • Automation Made Easy
      Automation Made Easy  3 months ago +1

      Try with the technique mentioned in the below tutorial:ru-clip.net/video/-GUw22ecRwI/video.html

    • Hamim Rahman
      Hamim Rahman 3 months ago

      +Automation Made Easy Brother did you get time to check this? please help me

  • Jaber Shabaneh
    Jaber Shabaneh 6 months ago

    Hi Ashu , great video, how come this doesn't work with Oracle web page even its html based, any thoughts to make it work with Oracle accounting , it doesn't identify the page as document eventhough it has html text

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Your welcome.

    • Jaber Shabaneh
      Jaber Shabaneh 6 months ago

      +Automation Made Easy I appreciate it, I wish if I can share the url , but its secured work url cannot be opened from else where , I'll keep trying with different methods maybe it has something to do with being javascript. Thanks my freind.

    • Automation Made Easy
      Automation Made Easy  6 months ago

      I have not worked on Oracle accounts page. Can you please share the url of any such page. May be I can do some research and try to find a solution.

  • Artur Mamedov
    Artur Mamedov 6 months ago

    Hi, what happens if the element does not have an ID?

    • Jose Docavo
      Jose Docavo 6 months ago

      Hi, again. Now I see the snippet code, it was hidden, still do not manage to work. This is my web form: ballrescuer.convertri.com/suscriptores-protocolo
      Thanks

    • Jose Docavo
      Jose Docavo 6 months ago

      +Automation Made Easy Hello Ashu, great job. I am having the same problem, no id in my web form. What dou you mean by below code snippet to use name attribute? I try to use IE.document.getElementByName but it comes an time error all the time. Could you give a solution? Thanks

    • Automation Made Easy
      Automation Made Easy  6 months ago

      You could use other attributes. Below code snippet shows how to use name attribute.
      Let me now if you have further questions.

      Set btns = IE.document.getelementsbyname("NameAttribute")
      For Each b In btns
      strBtn = b.name
      If strBtn = "Sign Up" Then
      b.Click
      Exit For
      End If
      Next

      Note:'NameAttribute' must be the actual name found in HTML text.

  • Fiona M
    Fiona M 6 months ago

    Thanks for your video, super helpful! I am trying to do what you suggested at the end and run a loop to get to fill a form with details from the first row from excel, submit it and move to the next row.. I can get it to do it once but can't figure out a loop code that works.. could you help?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      Refer the tutorial in the link given below:
      ru-clip.net/video/vnIsNa4de7M/video.html
      Let me know if you have any other questions.

  • A R
    A R 6 months ago

    Ashu, How much to hire you as a consultant?

    • Automation Made Easy
      Automation Made Easy  6 months ago +1

      Please share your contact details on my email easilyautomateashu@gmail.com

  • Aayushi Shah
    Aayushi Shah 6 months ago

    I get run time error 438. How do I solve it? I think I am using incorrect id to fill in data.Can anybody help?

    • Automation Made Easy
      Automation Made Easy  6 months ago

      This error occurs when incorrect property is getting used. Can you share the code you have written as well as the web url.

  • Mr Singh
    Mr Singh 7 months ago

    i have one question about login button when inspect element on login button there is no id show then how would i connect through vba.

    • Automation Made Easy
      Automation Made Easy  7 months ago

      Well you could use the text displayed on the button to uniquely identify it, But that wiil need some coding. Try using the code snippet below. Let me now if you have further questions.

      Set btns = IE.document.getelementsbytagname("button")
      For Each b In btns
      strBtn = b.outerText
      If strBtn = "Sign Up" Then
      b.Click
      Exit For
      End If
      Next

      Note: 'outerText' is the text displayed on the button

  • Harish Thakur
    Harish Thakur 7 months ago

    want to discuss something....need ur 5 min 9039225268

  • BILAL AH
    BILAL AH 7 months ago

    can i use this for auto filling forms

  • Mind Buzzing Articles
    Mind Buzzing Articles 7 months ago

    id is not showing up code when i select the button (Add new entity

    • Automation Made Easy
      Automation Made Easy  7 months ago

      Well you could use the text displayed on the button to uniquely identify it, But that wiil need some coding. Try using the code snippet below. Let me now if you have further questions.

      Set btns = IE.document.getelementsbytagname("button")
      For Each b In btns
      strBtn = b.outerText
      If strBtn = "Sign Up" Then
      b.Click
      Exit For
      End If
      Next

      Note: 'outerText' is the text displayed on the button

    • Automation Made Easy
      Automation Made Easy  7 months ago

      we can try to co-ordinate on weekend. Add my email id on google chat.
      easilyautomateashu@gmail.com

    • Mind Buzzing Articles
      Mind Buzzing Articles 7 months ago

      you will not have access to it, if you can tell me when you are available i can share my screen. thanks

    • Automation Made Easy
      Automation Made Easy  7 months ago

      Please share the url of the web page.

  • dibyendu mondal
    dibyendu mondal 7 months ago

    how to select an option from drop down list through vba excel.


    BANKNIFTY





    BANKNIFTY

    FTSE100

    NIFTY

    NIFTYCPSE

    NIFTYINFRA

    NIFTYIT

    NIFTYMID50

    NIFTYPSE

    • Automation Made Easy
      Automation Made Easy  7 months ago

      Please share the url of the page, that would be easier for me to analyze and provide a solution.

  • Valerie Hicks
    Valerie Hicks 7 months ago +1

    I get a Run-time error "91" - Object Variable or With block variable not set on one of the fields on my web form. How do I resolve this?

  • Animesh Viz
    Animesh Viz 8 months ago

    Thanks bro

  • Dr. Rama Reddy T
    Dr. Rama Reddy T 8 months ago

    Ashu, excellent way of explanation. Trying to automate some web forms data entry, solicit your support. Thanks.

  • UBAID POOKOTTUR
    UBAID POOKOTTUR 8 months ago

    Ashu,,,very informative video. I want to know how to fill a form which is already opened in website?

    • Automation Made Easy
      Automation Made Easy  8 months ago

      Sub GetIE()

      Dim sh As ShellWindows
      Dim IE As InternetExplorer

      Set sh = New ShellWindows
      For i = 0 To sh.Count - 1

      If sh.Item(i).LocationURL = "your URL" Then
      Set IE = sh.Item(i)
      Exit For
      End If
      Next

      'Perform your actions here using IE object

      End Sub

  • Rajesh Kumar
    Rajesh Kumar 8 months ago

    Is it possible to fill this details for the tab which is already open or logged in??

    • UBAID POOKOTTUR
      UBAID POOKOTTUR 8 months ago

      Your URL: if this URL is hanging for every submission, what to do.

    • Automation Made Easy
      Automation Made Easy  8 months ago +1

      yes Rajesh. Below code snippet can be used to achieve the same.

      Sub GetIE()

      Dim sh As ShellWindows
      Dim IE As InternetExplorer

      Set sh = New ShellWindows
      For i = 0 To sh.Count - 1

      If sh.Item(i).LocationURL = "your URL" Then
      Set IE = sh.Item(i)
      Exit For
      End If
      Next

      'Perform your actions here using IE object

      End Sub

      Note: This woks fine with IE upto version 11.

  • Bhavin Prajapati
    Bhavin Prajapati 8 months ago

    Great Ashu... I am zero at VB coding but you explained very well here. But i need your help, in this video .. how to use 'loop' for next raw data.

    • Automation Made Easy
      Automation Made Easy  8 months ago

      Thanks Bhavin. Below video shall solve your doubts.

      ru-clip.net/video/vnIsNa4de7M/video.html

  • kevshahfl
    kevshahfl 9 months ago

    Ashu, Excellent Job! Your videos are clear, easy to follow, one of the best in this area. Thanks Raj

  • Jonathan Ho
    Jonathan Ho 9 months ago +1

    Awesome! You have a very effective way of teaching programming!

  • Ajaynaidu ajay
    Ajaynaidu ajay 9 months ago

    Hi I am getting error as run time error'-2147467259(80004005)'
    Method 'Document' of object 'iwebbroweser2'failed

    • Automation Made Easy
      Automation Made Easy  9 months ago

      yes please send the file. I will try to recreate and resolve your issue.

    • Ajaynaidu ajay
      Ajaynaidu ajay 9 months ago

      That website which I am trying to open will with secure id so u can't open it .Can I send file

    • Automation Made Easy
      Automation Made Easy  9 months ago

      I am unable to re-create your issue. Can you send me your excel workbook at easilyautomateashu@gmail.com. Also let me know which version of IE and windows you are using.

    • Ajaynaidu ajay
      Ajaynaidu ajay 9 months ago

      I am getting error in getelementbyid line please verify and advice

    • Ajaynaidu ajay
      Ajaynaidu ajay 9 months ago

      Sub fromfilling()
      Dim IE As Object
      Set IE=createObject("InternetExplorer.Application")
      IE.Visiable =Ture
      IE.navigate ""
      Do While IE.Busy
      Application.Wait DateAdd("s",1,Now)
      Loop
      IE.documebt.getElementById("name_ei").Value="12345"
      End sub

  • Viral Wapp
    Viral Wapp 10 months ago

    Awesome..Keep making videos on Excel Macros..Your way of execution is nice

  • MGNREGA-CELL BHAGWANPUR-II BLOCK

    Sir kya apka mobile no. mil sakta hai. mujhe kuch baat karna hai apse excel ke regarding. please sir. mera no. 08436039869

    • Automation Made Easy
      Automation Made Easy  10 months ago

      Aap muje google chat meh add kar lijiye. Email id: easilyautomateashu@gmail.com

  • Prince Soni
    Prince Soni 11 months ago

    Hii i have create the coe but my data is not getting filled in he specified cell

    Error 424

    Sub Test1()
    Dim IE As Object
    Set IE = CreateObject("InternetExplorer.Application")
    IE.Visible = True
    IE.navigate "services.gst.gov.in/services/login/"
    Do While IE.Busy
    Application.Wait DateAdd("s", 1, Now)
    Loop
    IE.document.getElementById("#username").Value = "test"
    End Sub

    • Automation Made Easy
      Automation Made Easy  11 months ago

      Hi Prince,
      The ID which you have used contains extra '#' symbol. The id is "username" not '#username'. Also the page is taking a while to load so it would be a good idea to insert some wait before entering the value in the text box. Please try with the code snippet given below:
      Sub Test1()
      Dim IE As Object
      Dim doc As HTMLDocument
      Set IE = CreateObject("InternetExplorer.Application")

      IE.Visible = True
      IE.Navigate "services.gst.gov.in/services/login"

      Do While IE.Busy
      Application.Wait DateAdd("s", 1, Now)
      Loop

      Set doc = IE.document

      Application.Wait DateAdd("s", 4, Now)
      IE.document.getElementById("username").Value = "test"
      IE.document.getElementById("user_pass").Value = "test"

      End Sub