Hi, in this video you've mentioned you'll create a separate video for making for loop to enter data from multiple rows, I searched for the same but could not find it, can you pl. share the link. Also, 1) how do I select from dropdown in the webpage
Wwwwwwwwwwwwwwwwwwooooooooooooooooooooooooooooowwwwwwwwwwwww. Each and every day I am learning how powerful excel is. Thank you for this wonderful tutorial! Very relevant to my job, would love to implement it.
I was wondering why the intelisence was not working when watching other tutorials. Now you explained why , so thanks for this valuable information and the whole video is awsone
Thanks for taking the time to explain this and especially for your careful and detailed explanation - as others have said your teaching method of explaining the process and the code is excellent. Yes I too would like to see the enhancement using formloop for multi row tables, plus a way to ensure that the macro only writes new rows of data to the form ( i guess you would need to incorporate an IF function in VB that looked if the row had been posted and that could work of a new column in the spreadsheet "Already Posted?" that the posting macro would update with "Yes" as it posted a row before looping to the row, checking if it had been posted and then posting it if required. is there any reason that this could not be done using Googlesheets instead?
Hi, its simply awesome. Easily understandable.. Thank you so much.. But i hav a another problem... For one personal website, After click the submit button, im getting another page.. In that i have to click one hyperlink.. So how can i do that for mulitiple followup hyperlinks .. Pls help with this
@@AutomationMadeEasy Sure will check out ... this is for single range ..but i need to fill for range of cells .i.e one full column( leaving out the header) in that case?
Watching your video first time and I must to say you are awesome.. big fan of your way of teaching. Learn alot and I hope you will continue this wonderful teaching skills ... Big Respect and Big Love from Pakistan..❤️❤️❤️
I am very much impressed with your video. It is highly useful to me. I need to know two things. 1.How to use for loop for multiple data 2.How to use for next page of form after submission
Thanks for the education. Did you ever create a separate tutorial you mentioned about the for loop to populate multiple rows? I couldn’t find it. I need to automate repeat actions that will search a value that will open another tab that will need to be populated and closed.
@@AutomationMadeEasy hi- once a form is submitted another one takes its place - so excel vba needs to wait till the new form is presented - then ofcourse the do loop can continue filling. so how to know if the new webpage form is presented please
Hi, super helpful. Thanks for that. How can i fill data into further forms after the login (without login out)? I get redirected and I can't select buttons with getElementByID?
Your video is useful .In this video you help to populate text on homepage text box of Facebook, I have a scenario where the home page is login page and data entry is done on second page after login. So through this process I am unable to solve my purpose.I subscribed your channel and eagerly waiting for video .
Thanks for the video. I'm currently stuck as it appears that the ID for my input fields on my particular webpage are dynamic and change with every refresh. I'm unable to identify my field by ID or name as they are always changing. Is there a workaround for this?
Hi there, thanks for this. How could this code be changed to read the next line row of the spreadsheet once the sub-routine has finished? You mentioned this at the end via Loops but i cannot see the relevant video. I'm thinking it would be an offset of each value and then loop until all rows are done?
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?
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
I have made sure the References are set up correctly etc., and the page I am going to opens fine, but keep getting Run-time error '462': The remote server machine does not exist or is unavailable. This happens on "Set doc = IE.document" line. When I disable/change to comment for that line, and change the "doc.getElementByID..." to "IE.document.getElementByID...", I get the runtime error on the "IE.document.getElementByID..." line. Do you have any suggestions?
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??
Its a really helpful video, your demonstration is just amazing for all level of users. I just have a quick question if you could help me with. I just want a help with dropdown items, my requirement is to automate a web based userform, which mainly have user inputs in form of dropdown list. And i have data in excel, so just wanted to know how to use different dropdown value inputs in for loop. It would be really appreciable if you you could guide me with this.
Bhaiya bahut hi Badiya video banaya he. 👌👌 Pr ek request he. Ki hindi me ek esa video banaiye jisse hum excel ke data ko web pr automatically entry kr sake. Mtlb single click me 10000 entry online.. browser pr.plz 🙏🙏
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?
Thanks sir for sharing such a very useful information. Sir can you guide me that how to fill data on active browser page (already opened page) rather opening every time open a new page.
Hi AME, Thanks for video, it was very helpful. A problem I am having by using the following code in a multi-extract situation to extract data from numerous websites: IE.document.getElementById("direct_jobDescriptionText").innerText If one of the webpages listed in an Excel sheet has expired (and so ID "direct_jobDescriptionText" does not exist), the VBA code results in a runtime error. Do you have code to check if ID exists before data is extracted? Thanks.
Hi, Given info is useful, further, I need to fill data from .xls in web page and save each entry, I need to know how to make entries from each row and save?
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?
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 ua-cam.com/video/vnIsNa4de7Mh/v-deo.htmlttps://ua-cam.com/video/vnIsNa4de7M/v-deo.html For execution on chrome browser refer below video: ua-cam.com/video/-GUw22ecRwI/v-deo.html
Thank you for your video, I am facing a stiuation where the html elements in the web site is generated dynamically and the id of the elemement cannot be identified before the html page is created. how to solve this issue?
Thanks a lot for the video. A query I am having is I want to fill the Last Name field for some entries. Some entries are blank in the excel workbook as lastname is not a mandatory field. Now when I run with the last name field blank in excel then I am getting "undefined" in the web page. How to solve.
store last name in a variabe and use an if condition as geiven below: lname =ThisWorkBook.Sheets("SheetName").Range("B2").text if lname "" 'Code to populate last name End if
Excellent video man! I know nothing about macros and this helped a ton. I watched your web scraping video and I'm still having an issue running my macro for multiple rows. Any tips for looping through multiple rows after clicking the submit button? I would assume the entire macro has to run again because after clicking submit you would be on a completely new webpage... How can I edit my macro to read the next row down after looping?
You will hve to nvigate to the page from where u start filling the data just before you start the next iteration. I will have to see your web page to suggest optimal solution.
Hi, I have a question. Need your help. I have a form that takes data and submits it. I have an excel sheet with rows of data. I need to fill all the data. Is it possible? I mean it takes data from one row submits it and then comes back to 2nd row...and so on. Please advise.
How do you get it to click the "sign up" button? I have done something similar, but am trying to use it to put in my credentials, and click a "LOGIN" button, but when I inspect the page, the login button doesn't have an id .. instead, when I inspect the login button it says any tips for getting it to click the login button after the information has been put into the browser?
thank you for sharing this tutorial. However I am trying to use the same code and I am getting an error Method 'Document' of object 'IWebBrowser2' failed. Any resolution to this?
VEry good video, i have one question, imagine if i want to use the listbox for exemple when the code run when it comes to days/month year it prompt me a message that says please select from the list. instead of having the values on this excel book
Thank you for the very detailed video. Let me ask why at line doc.getElementsByName ("uidPasswordLogon"). Click when pressing space mark does not show up click and when run yellow error at line Set doc = IE.document
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.
Hello, thank you for putting such a informative video. I have a question on what we can do to fill out form once we log in? For an example internal website I was able fill in password and username and was able to login. Now I want to fill out new user form. Currently there is header and out of few titles one of them is “User” when we hover over mouse it pops up Add User , Search user etc. Once we click on Add User it opens up web form . How with the macro we can achieve to populate this web form automatically with the data from excel
Well it is possible to automate but I will need to see the form to sugest a solution. Refer below tutorial and check if it helps: ua-cam.com/video/AEp0Yeis9AM/v-deo.html
Hi Automation Made Easy, I'm trying upload an excel file into a website using excel and MS Edge. I've followed your code, but can't seem to get MS Edge to launch (create object error: Run-time error '-429': ActiveX component can't create object). Have you run into this error before? Thanks in advance, Roger
it will work on Internet explorer not on edge. If you want to automate using chrome browser refer below tutorial: ua-cam.com/video/-GUw22ecRwI/v-deo.html
Thank you very much for your amazing videos, it is very helpful. Can the code be more dynamic by executing the active row instead of hard coding i.e. "first.name". When you are in the row you wish to send to the web form, run the macro and it extracts only the row where the cursor is located.
below tutorial shall be helpful. It does not get triggered on addition of each row but it allows you to submit data for all the rows in one go. ua-cam.com/video/docnLSdj8rI/v-deo.html
@@AutomationMadeEasy thanks, I have had a look but it seems to be a scraping tool. I would like to run the code to fill the active row info. I can then manually submit once I am happy and start the new form again with the next row in excel. Is that possible?
Thanks a lot for the useful video, Would you please to help me that for example after fill forms, web response some numbers in a table, so I want to copy one number of table to a cell A2, how can I do this?
How do I modify this code if I would like to input date from excel into Google Chrome. Also, I have the data stored in Google Sheets (Online) so would macro's work through that?
Thank you. I have a question. How do you make your Excel cells dynamic? I have to fill in a web page's form with a zip code and a button click. I've written (borrowed the VBA script from somewhere on the web). And modified it for my purposes. But I don't want the range(s) hardcoded in my VBA script. I want to select them randomly when I need them.
@@AutomationMadeEasy Thank You very much. It's way more than I asked for, but I'll take it. But if you could bear with me, I wanted to go slow. I'll eventually use your tutorial to perform the complete job. But right now I wanted to do one instance of clicking on one cell in the Excel spreadsheet. And have that zip code modify the Range in the VBA script. And be placed in the Enter Your Zip Code box on the web page. the Range is ("A3") in the example: IE.Document.All("ctl00$BlockFillContent$zsh$txtLookupAddress").Value = ThisWorkbook.Sheets("Massachusetts").Range("A3")
@@AutomationMadeEasy I'm not going to waste your time. You've already answered my next two questions. So I'm going to learn from your tutorial and adapt it to my total project, not just one cell. I'll let you know if I have a problem. Thanks again, you've got me hooked on making macros.
Hello, I love your videos. Do you have any advice on how to set values on a hidden input type. I can find the element but when I try to set it I get 'element not interactable'
@@AutomationMadeEasy Hi I cant send site as its confidential behind a login. But an example is below its the c_zone , c_zone_2 etc. values which I need to update Country: Export Tariff zone: document.write(zn[0])NationalNon Docs Charge: FedEx Express retail zone: document.write(zn[0])NationalDHL Road retail zone: document.write(zn[0])NationalEconomy retail zone: document.write(zn[0])NationalDHL Express retail zone: document.write(zn[5])DHL Express Zone 5
Thanks for your useful video. I have a question: In case the fields on the webpage don't have the ID and just have a class attribute, how can we address and enter the data from the spreadsheet to them?
Could you let me know what is the video with the tutorial to add multiple rows into a web page? You mention it at the very end but I can't find any. Thanks a lot. Also, if you know a way to click into a link that is generated after entering the data. It's a link relative to the entered data so it changes every time. I can't figure it out.
@@AutomationMadeEasy Thanks a lot, It's working a lot better but I can't quite make it add several rows. So if you can help me I will appreciate it. Also after part of the process is done, the name of the website where I enter the data page change to a differrent name and it's a different name every time so I don't know how to make the script understand this. Let me know if you can help.
Hi, in this video you've mentioned you'll create a separate video for making for loop to enter data from multiple rows, I searched for the same but could not find it, can you pl. share the link.
Also, 1) how do I select from dropdown in the webpage
Wwwwwwwwwwwwwwwwwwooooooooooooooooooooooooooooowwwwwwwwwwwww. Each and every day I am learning how powerful excel is. Thank you for this wonderful tutorial! Very relevant to my job, would love to implement it.
Wonderful!
Most amazing person, to present in such a clear and logical way and will make it easy for learner of all levels to understand. Great job.
So nice of you
I was wondering why the intelisence was not working when watching other tutorials. Now you explained why , so thanks for this valuable information and the whole video is awsone
Awesome! You have a very effective way of teaching programming!
Thank you
@@AutomationMadeEasy IE.Visble = True shows "Runtime Error 438" Kindly help
Wow!! I have never come across such simple explanation. Thanks man. You style is just amazing.
Glad you liked it!
How to use this method for multiple links at the same time with same work sheet
My brain hurts .... thank you so very much for your care in making this! This is truly awesome and a huge help. Well done!!!😃
Hi did you used this
Thanks for taking the time to explain this and especially for your careful and detailed explanation - as others have said your teaching method of explaining the process and the code is excellent. Yes I too would like to see the enhancement using formloop for multi row tables, plus a way to ensure that the macro only writes new rows of data to the form ( i guess you would need to incorporate an IF function in VB that looked if the row had been posted and that could work of a new column in the spreadsheet "Already Posted?" that the posting macro would update with "Yes" as it posted a row before looping to the row, checking if it had been posted and then posting it if required.
is there any reason that this could not be done using Googlesheets instead?
efer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
@@AutomationMadeEasy I believe the link you posted was for scraping. Do you have a tutorial to do a loop to handle the multiple entries?
@@damienhawthorne8864 if you found that please let me know , im also looking for that
This tutorial is a masterpiece… ❤
thsnk you
Hi, its simply awesome. Easily understandable.. Thank you so much.. But i hav a another problem... For one personal website, After click the submit button, im getting another page.. In that i have to click one hyperlink.. So how can i do that for mulitiple followup hyperlinks .. Pls help with this
This is one of the far most beautifully explained video on macros for Data Entry....keep up the good work buddy.....
Thank You
@@AutomationMadeEasy I need a help from you in a vba coding. I dont mind paying for it though...please suggest how we can discuss on it
Email me on automationandagile@gmail.com
Great video, thank you
how to submit the data entry after filling, if there's a submit button
IE.Document.getElementById("ID of submit button").click
@@AutomationMadeEasy what if there is no id for the submit button?
Refer below tutorial:
ua-cam.com/video/Qknt8qFR7kY/v-deo.html
@@AutomationMadeEasy Sure will check out ... this is for single range ..but i need to fill for range of cells .i.e one full column( leaving out the header) in that case?
Wow, nice explanation. After ur explanation I am aware that we can automate the webform using Excel also.
Thanks a lot.
You are most welcome
You are a very good explainer. Got the perfect knowledge. Thanks and would like to see new automations.😊
So nice of you
Great video, you just saved my hours of work. Thanks
Glad it helped
Watching your video first time and I must to say you are awesome.. big fan of your way of teaching.
Learn alot and I hope you will continue this wonderful teaching skills ...
Big Respect and Big Love from Pakistan..❤️❤️❤️
So nice of you
I am very much impressed with your video. It is highly useful to me.
I need to know two things.
1.How to use for loop for multiple data
2.How to use for next page of form after submission
refer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Bro this is still gold years later.
thanks
Thanks for the education. Did you ever create a separate tutorial you mentioned about the for loop to populate multiple rows? I couldn’t find it. I need to automate repeat actions that will search a value that will open another tab that will need to be populated and closed.
Very good at explaining and demonstrating Thank You!!
Your welcome
Hi... Thanks for the video... I am encountering an error “ 462 the remote server machine does not exist or is unavailable “... can you please help
Awesome bro perfect explanation and very helpful
Glad you liked it
Watched just now and it's awesome explained
Thank you for this tutorial it was very helpful
You’re welcome 😊
Nice video, very well explained. Thanks
You're welcome!
How do I use ElemenByID syntax if there is no ID field in the webpage and expects a user input in that field?
Thanks, one question, my page moves to next page and code is not able to continue, any suggestions?
You are a true hero, man!
thanks
@@AutomationMadeEasy hi- once a form is submitted another one takes its place - so excel vba needs to wait till the new form is presented - then ofcourse the do loop can continue filling. so how to know if the new webpage form is presented please
Hi, super helpful. Thanks for that.
How can i fill data into further forms after the login (without login out)? I get redirected and I can't select buttons with getElementByID?
Thanks in a million. Great content. Awesome imagination. Just subscribed. Grade: A++💥
Awesome, thank you!
very useful.. you explained it well. like to see more videos of yours
Thank you
Awesome bro, today I got some work and this video made my day.
thank you.
thank you for a very interesting video and new to learn! I have been trying to find out how to launch the IE maximized, is there a easy way?
Is there is any way or code to clear the filled form in the chrome site using excel VBA?
आपका वीडियो बहुत अच्छा है आपके वीडियो से बहुत कुछ सीखा जा सकता है और वेब पेज पर यूज भी किया जा सकता है सर इस वीडियो को हिंदी में बनाइए🙏
thank u
You are awesome and very helpful and kind bless you
Thank you
@@AutomationMadeEasy you deserve but where is the second part
Its right here:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Ashu, Excellent Job! Your videos are clear, easy to follow, one of the best in this area. Thanks Raj
Thanks for the encouraging words.
Your video is useful .In this video you help to populate text on homepage text box of Facebook, I have a scenario where the home page is login page and data entry is done on second page after login. So through this process I am unable to solve my purpose.I subscribed your channel and eagerly waiting for video .
Fantástico meu amigo. Muito obrigado! Mais um inscrito... Abraços desde o Brasil a você e sua família. Sejam bem vindos.
thank u
Wonderfully explained with clear instructions. Subscribed your channel to learn more in the future. Cheers Buddy!
Awesome, thank you!
Thanks for the video. I'm currently stuck as it appears that the ID for my input fields on my particular webpage are dynamic and change with every refresh. I'm unable to identify my field by ID or name as they are always changing. Is there a workaround for this?
refer below tutorial for alternate approach:
ua-cam.com/video/AEp0Yeis9AM/v-deo.html
Thanks a lot for sharing useful contents! :D
Glad you like them!
Hi there, thanks for this. How could this code be changed to read the next line row of the spreadsheet once the sub-routine has finished? You mentioned this at the end via Loops but i cannot see the relevant video. I'm thinking it would be an offset of each value and then loop until all rows are done?
Refer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
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?
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
I have made sure the References are set up correctly etc., and the page I am going to opens fine, but keep getting Run-time error '462': The remote server machine does not exist or is unavailable. This happens on "Set doc = IE.document" line. When I disable/change to comment for that line, and change the "doc.getElementByID..." to "IE.document.getElementByID...", I get the runtime error on the "IE.document.getElementByID..." line. Do you have any suggestions?
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??
Its a really helpful video, your demonstration is just amazing for all level of users. I just have a quick question if you could help me with. I just want a help with dropdown items, my requirement is to automate a web based userform, which mainly have user inputs in form of dropdown list. And i have data in excel, so just wanted to know how to use different dropdown value inputs in for loop. It would be really appreciable if you you could guide me with this.
Below tutorial shall serve your purpose:
ua-cam.com/video/docnLSdj8rI/v-deo.html
This video really helped me. Thank you soo much.
your welcome
What if we have the same particulars and multiple data sets in the rows
Thank you very much for explaining this!
Your welcome
if i have multiple and variable data entry to insert into the same a web form?
Refer the syntax provided in below tuturial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
@@AutomationMadeEasy thank you
wao what an amazing tutorial .. now i am working on cliking and then if soemthing hapens stop if something else then choose next email very cool
How can I just fill the web without have to load new one?
do you have the same, but compatible with google chrome ?
Refer below:
ua-cam.com/video/-GUw22ecRwI/v-deo.html
Great content!Very nicely elucidated!! 👍
Glad you liked it
Bhaiya bahut hi Badiya video banaya he. 👌👌
Pr ek request he. Ki hindi me ek esa video banaiye jisse hum excel ke data ko web pr automatically entry kr sake. Mtlb single click me 10000 entry online.. browser pr.plz 🙏🙏
thank u
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?
I sent you the solution on your email
@@AutomationMadeEasy - Can you please send me the code for the above as well ?
Very nice .
Can we use this same for any government based portal i.e. ESIC to get ESIC number?
And how to do bulk work for this?
Thanks sir for sharing such a very useful information. Sir can you guide me that how to fill data on active browser page (already opened page) rather opening every time open a new page.
What if you have multiple rows in excel and same IE form? Thanks! (as per your example, create multiple accounts)
refer below tutorial fro syntax:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Awesome video! However, what happens if the field I'm wanting to prepopulate has no ElementID? Thanks.
thanks.refer below tutorial
ua-cam.com/video/Qknt8qFR7kY/v-deo.html
Very useful! Just on the dropdowns; how does one select multiple values (which are then stored via onchange on the website)?
I will have to se the webpage or you may refer to alternate technique explained in below tutorial:
ua-cam.com/video/-GUw22ecRwI/v-deo.html
Awesome..Keep making videos on Excel Macros..Your way of execution is nice
Thank you.
Hi Sir can you help me to clear browsing history after each single entry
Useful video bro.
Waiting for another video where multiple entry is required in web😍
here is the tutorial you are looking for:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Thanks for the informative video.
Is there a way you can do this the other way around?
ex. From Web data to Excel.
Certainly yes. Refer below tutorials:
ua-cam.com/video/docnLSdj8rI/v-deo.html
ua-cam.com/video/iIhEyrYfqbA/v-deo.html
Hi AME,
Thanks for video, it was very helpful.
A problem I am having by using the following code in a multi-extract situation to extract data from numerous websites:
IE.document.getElementById("direct_jobDescriptionText").innerText
If one of the webpages listed in an Excel sheet has expired (and so ID "direct_jobDescriptionText" does not exist), the VBA code results in a runtime error.
Do you have code to check if ID exists before data is extracted?
Thanks.
workarounds are possible but I will need to see the url to provide a solution.
Thanks for sharing this. The video is very informative.
Is there any video explaining the for loop function?
refer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Hi, Given info is useful, further, I need to fill data from .xls in web page and save each entry, I need to know how to make entries from each row and save?
refer below tutorial for the syntax you are looking for:
ua-cam.com/video/docnLSdj8rI/v-deo.html
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?
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
ua-cam.com/video/vnIsNa4de7Mh/v-deo.htmlttps://ua-cam.com/video/vnIsNa4de7M/v-deo.html
For execution on chrome browser refer below video:
ua-cam.com/video/-GUw22ecRwI/v-deo.html
Thank you for your video,
I am facing a stiuation where the html elements in the web site is generated dynamically and the id of the elemement cannot be identified before the html page is created. how to solve this issue?
need to see the web page
Super tutorial, Can you make video on How to extract data from website and put all data into textboxs(macro userform) in excel sheet
nice way and very simplifed.... thanks
Your welcome
Excellent !!! Very helpful !!!
thank you
Is this applicable in Open Office ?
What about looping through multiple rows of excel data to input into an IE site?
Refer below tutorial
ua-cam.com/video/vnIsNa4de7M/v-deo.html
Thank you for the video! Is this method possible with the Microsoft EDGE browser?
No. You can refer below tutorial for Chrome browser
ua-cam.com/video/-GUw22ecRwI/v-deo.html
@@AutomationMadeEasy IE.Visble = True shows "Runtime Error 438" Kindly help
Thanks a lot for the video. A query I am having is I want to fill the Last Name field for some entries. Some entries are blank in the excel workbook as lastname is not a mandatory field. Now when I run with the last name field blank in excel then I am getting "undefined" in the web page. How to solve.
store last name in a variabe and use an if condition as geiven below:
lname =ThisWorkBook.Sheets("SheetName").Range("B2").text
if lname ""
'Code to populate last name
End if
Excellent video man! I know nothing about macros and this helped a ton. I watched your web scraping video and I'm still having an issue running my macro for multiple rows. Any tips for looping through multiple rows after clicking the submit button? I would assume the entire macro has to run again because after clicking submit you would be on a completely new webpage... How can I edit my macro to read the next row down after looping?
You will hve to nvigate to the page from where u start filling the data just before you start the next iteration.
I will have to see your web page to suggest optimal solution.
Hi,
I have a question. Need your help. I have a form that takes data and submits it. I have an excel sheet with rows of data. I need to fill all the data. Is it possible? I mean it takes data from one row submits it and then comes back to 2nd row...and so on. Please advise.
Certainly you can automate the task. Refer the below tutorial. It shall serve your purpose.
ua-cam.com/video/docnLSdj8rI/v-deo.html
How do you get it to click the "sign up" button? I have done something similar, but am trying to use it to put in my credentials, and click a "LOGIN" button, but when I inspect the page, the login button doesn't have an id .. instead, when I inspect the login button it says any tips for getting it to click the login button after the information has been put into the browser?
refer below tutorial:
ua-cam.com/video/Qknt8qFR7kY/v-deo.html
thank you for sharing this tutorial. However I am trying to use the same code and I am getting an error Method 'Document' of object 'IWebBrowser2' failed. Any resolution to this?
Are you executing on intranet?
VEry good video,
i have one question, imagine if i want to use the listbox for exemple when the code run when it comes to days/month year it prompt me a message that says please select from the list. instead of having the values on this excel book
use message boxes before the code to select the value. Syntax given below:
Msgbox "Enter Value"
Thank you for the very detailed video. Let me ask why at line doc.getElementsByName ("uidPasswordLogon"). Click when pressing space mark does not show up click and when run yellow error at line Set doc = IE.document
it should be doc.getElementsByName ("uidPasswordLogon")(0).click
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.
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.
doc.getElementsByName("roof-last-name")(0).Value = "test1234"
With above code you would be able to identify the web element without having id's
@@AutomationMadeEasyin my website some buttons don't have id or name, now what can I do?
Hello, thank you for putting such a informative video. I have a question on what we can do to fill out form once we log in? For an example internal website I was able fill in password and username and was able to login. Now I want to fill out new user form. Currently there is header and out of few titles one of them is “User” when we hover over mouse it pops up Add User , Search user etc. Once we click on Add User it opens up web form . How with the macro we can achieve to populate this web form automatically with the data from excel
Well it is possible to automate but I will need to see the form to sugest a solution. Refer below tutorial and check if it helps:
ua-cam.com/video/AEp0Yeis9AM/v-deo.html
Hi Automation Made Easy, I'm trying upload an excel file into a website using excel and MS Edge. I've followed your code, but can't seem to get MS Edge to launch (create object error: Run-time error '-429': ActiveX component can't create object). Have you run into this error before? Thanks in advance, Roger
it will work on Internet explorer not on edge. If you want to automate using chrome browser refer below tutorial:
ua-cam.com/video/-GUw22ecRwI/v-deo.html
Hi sir, can I use the same logic to fill a sharepoint list? Please help I want to create a macro to move local excel data to sharepoint list.
can you share the link of the the SP site I can take a look and let you know
Hi , do we need IE Admin to find out about field Ids or is there any other way
on any browser you have to right click on the web element and click on inspect.You will be able to it html properties.
Nice & Thanks for creating this type video. I am also a youtube and already I also create a video on this topic.
Hi,
How to do it for dependent drop down fields?
I tried above trick but its only selecting 1st drop down: like State not working for Cities
refer alternate approach explained in below tutorial:
ua-cam.com/video/AEp0Yeis9AM/v-deo.html
Thank you very much for your amazing videos, it is very helpful. Can the code be more dynamic by executing the active row instead of hard coding i.e. "first.name". When you are in the row you wish to send to the web form, run the macro and it extracts only the row where the cursor is located.
below tutorial shall be helpful. It does not get triggered on addition of each row but it allows you to submit data for all the rows in one go.
ua-cam.com/video/docnLSdj8rI/v-deo.html
@@AutomationMadeEasy thanks, I have had a look but it seems to be a scraping tool. I would like to run the code to fill the active row info. I can then manually submit once I am happy and start the new form again with the next row in excel. Is that possible?
Thanks a lot for the useful video, Would you please to help me that for example after fill forms, web response some numbers in a table, so I want to copy one number of table to a cell A2, how can I do this?
refer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
How do I modify this code if I would like to input date from excel into Google Chrome. Also, I have the data stored in Google Sheets (Online) so would macro's work through that?
For chrome automation refer below tutorial:
ua-cam.com/video/-GUw22ecRwI/v-deo.html
It wont work with G sheets.
Thank you. I have a question. How do you make your Excel cells dynamic? I have to fill in a web page's form with a zip code and a button click. I've written (borrowed the VBA script from somewhere on the web). And modified it for my purposes. But I don't want the range(s) hardcoded in my VBA script. I want to select them randomly when I need them.
below tutorial shall serve your purpose:
ua-cam.com/video/docnLSdj8rI/v-deo.html
@@AutomationMadeEasy Thank You very much. It's way more than I asked for, but I'll take it.
But if you could bear with me, I wanted to go slow. I'll eventually use your tutorial to perform the complete job. But right now I wanted to do one instance of clicking on one cell in the Excel spreadsheet. And have that zip code modify the Range in the VBA script. And be placed in the Enter Your Zip Code box on the web page. the Range is ("A3") in the example:
IE.Document.All("ctl00$BlockFillContent$zsh$txtLookupAddress").Value = ThisWorkbook.Sheets("Massachusetts").Range("A3")
I do not completely undersatnd your requirement. You can refer my contact mail in the about section of the channel. I will work with you.
@@AutomationMadeEasy I'm not going to waste your time. You've already answered my next two questions. So I'm going to learn from your tutorial and adapt it to my total project, not just one cell. I'll let you know if I have a problem. Thanks again, you've got me hooked on making macros.
Great. All the best :)
Hello, I love your videos. Do you have any advice on how to set values on a hidden input type. I can find the element but when I try to set it I get 'element not interactable'
I need to see your web site to suggesst a solution
@@AutomationMadeEasy Hi I cant send site as its confidential behind a login. But an example is below its the c_zone , c_zone_2 etc. values which I need to update Country: Export Tariff zone: document.write(zn[0])NationalNon Docs Charge: FedEx Express retail zone: document.write(zn[0])NationalDHL Road retail zone: document.write(zn[0])NationalEconomy retail zone: document.write(zn[0])NationalDHL Express retail zone: document.write(zn[5])DHL Express Zone 5
this does not help. Write into info@automationandagile.com if you would need zoom session
Thanks for your useful video. I have a question: In case the fields on the webpage don't have the ID and just have a class attribute, how can we address and enter the data from the spreadsheet to them?
Example for element without id is given in below tutorial:
ua-cam.com/video/AEp0Yeis9AM/v-deo.html
@@AutomationMadeEasy 🙏🏻🙏🏻
Hi sir, have you made your next videos using for loop? If yes, please can you share the link
refer below tutorial:
ua-cam.com/video/docnLSdj8rI/v-deo.html
Could you let me know what is the video with the tutorial to add multiple rows into a web page? You mention it at the very end but I can't find any. Thanks a lot. Also, if you know a way to click into a link that is generated after entering the data. It's a link relative to the entered data so it changes every time. I can't figure it out.
refer below tutorial:
ua-cam.com/video/iIhEyrYfqbA/v-deo.html
@@AutomationMadeEasy Thanks a lot, It's working a lot better but I can't quite make it add several rows. So if you can help me I will appreciate it. Also after part of the process is done, the name of the website where I enter the data page change to a differrent name and it's a different name every time so I don't know how to make the script understand this. Let me know if you can help.
Share your email. I will get in touch.
@@AutomationMadeEasy franciscosilval@gmail.com