Thank You! great video! I've found another way to inspect the element is to use F12 and then click on the elements tab then click on the little ICON top left, it will let you click on anything you would like the information on. You end up in the same place that you displayed in video.
Excellent video and very helpful thank you!!!! Is there a way to have it move on to next ranges? So for instance i'm using this to prefill forms for work from excel data however, there's multiple lines and I need to submit one form for each client. So one would be ranges A-L row 2 (A2, B2, C2, etc) then we would submit, and the next would be A-L row 3 (A3, B3, C3, etc) and we would submit the next form. Hopefully that makes sense?
Hey there, great video! Just wondering is it possible to use, say, the entire coulmn A as the range rather than just A1? The form I am populating allows for multiple values to be entered so I want it to pull a long list of all values in column A (A1, A2, A3 etc until it finds a blank cell). Any help would be greatly appreciated :)
Thank you for the video! Very informative and helped me out a lot. I did have a question. After populating a form in IE, I tried to hit submit (via code and manually), but the form doesn't recognize that data has been populated. It has error validation that states the text boxes/combo boxes are empty. Do you know if there is a way to force the form to recognize the data? Thanks in advance!
Great effort man, however I have an issue with filling drop down lists on webpages using values in my excel sheet, and would like to ask as well about doing the whole thing in chrome instead of IE, what should I do to achieve that?
Thanks so much for posting this video. Do you think it could be done in Chrome as well? or is VBA inherently better in working with IE? (Perhaps with SendKeys in Chrome?)
i have tried to run your code the exact why you have it in video but when i get to the IE.Document.All("btnK").click i get an error stating that object doesn't support this property or method any ideas?
Hi Juzer, it can! You can use Chrome, Firefox, IE, Edge, and even an invisible browser using a free tool. More info here: excelvbaisfun.com/complete-web-automation-with-excel-vba/
Excellent video my friend. The issue I am having specifically, is that the IE window I need to populate is a popup html window, and therefore, has no URL. I need to be able to do the same thing, using the Title of the html window instead of the URL. I am able to open, the Google Login page, and have it prefill my textboxes and submit. The real issue lies in that, the text boxes are in a popup window. Seems it would be easy enough, but not so much.
ExcelVbaIsFun It's hard for me to think of anything outside of the Service Desk software we use at work. What happens is, when we create a ticket, it opens in a popup form with several Textboxes on it. I am able to find the title of the htmlwindow, and the name of all of the Textboxes, but can't figure how to pass the variable (data in the cell) to the textbox by using the Title of the htmldoc. Check the link in the original message I sent you. If I come across any examples online, that I can supply you, I will most definitely send them your way. Thanks again.
Dear Sir I have an excel spreadsheet with three column (A1=Employees names ,B1= Gross Salary , C1=Net Salary). I am looking for a code which automatically check employees name If employee name match than fill their gross salary and net salary. Please help me
I cant get this to work... When I run the macro it stops at .document and says compile error: Invalid or unqualified reference. Everything I read online says to make sure your reference microsoft internet controls (shdocvw.dll). Well I did and its still not working. If found tones of other scripts to click a button but the pretty much all use .document and I have the same problem with all of them. Any ideas?
I am having the same problem. Maybe if we can find the name of the FORM that the button sits in and call it's "submit" event. Anyone find the name of the form?
Just start an Excel workbook with VBA macros enabled. Then search for help on Macros. But, I must say, "This is not something to play with if you know nothing about it". Macros can be very powerful and dangerous. Start with beginner videos here on TH-cam, but better, if you have some money. Buy good book on Excel VBA, or take a course on Udemy, or Udacity.
I get an error, 424 "Object required" but it only comes up every 10 runs but once i move the file to another computer it will happen every run. Any advice on how to solve? My code is borderline identical but mine fills in multiple text boxes in internet explorer: Line that flags: IE.Document.All("quote[origin]").Value = ThisWorkbook.Sheets("IO").Range("a1")
Hi Carl, It could be that the element you're searching for is not yet loaded and may need to wait a second or two longer. Not sure exactly without testing of course. Have an amazing day! Thanks Dan
I know this video is very old, but I'm hoping someone will be able to answer me. This is exactly what I needed, however when I try to run it on a work computer I get the error: The object invoked has disconnected from its clients. Does anyone know how to fix this? I'm expected to have a program using this up and running asap
I am not sure why it is not working I have attempted this several times but the text does not show up when I run this macro, everything else seems to work fine but I do receive an error message: Automation error the object invoked has disconnected from its clients. any suggestions would be greatly appreciated
Are used to program computers back in 1989 but I still can't login to a simple website today !I can't find anybody to help me I have plenty of money why is it very simple phone number I can call to get help with these issues
![How To Allow ONLY Numbers and Decimals to a Textbox - [Free Download] - Excel VBA Training](http://i.ytimg.com/vi/XlR-7Gsgfew/mqdefault.jpg)
Thank You! great video! I've found another way to inspect the element is to use F12 and then click on the elements tab then click on the little ICON top left, it will let you click on anything you would like the information on. You end up in the same place that you displayed in video.
Nice simple explanation and demonstration. Wish I could give you more than one thumb up.
Excellent video and very helpful thank you!!!! Is there a way to have it move on to next ranges? So for instance i'm using this to prefill forms for work from excel data however, there's multiple lines and I need to submit one form for each client. So one would be ranges A-L row 2 (A2, B2, C2, etc) then we would submit, and the next would be A-L row 3 (A3, B3, C3, etc) and we would submit the next form. Hopefully that makes sense?
I have the same question
Hey there, great video!
Just wondering is it possible to use, say, the entire coulmn A as the range rather than just A1?
The form I am populating allows for multiple values to be entered so I want it to pull a long list of all values in column A (A1, A2, A3 etc until it finds a blank cell).
Any help would be greatly appreciated :)
Perfect.. I was getting crazy looking for it - works perfectly... Thanks a lot
thanks for video. it was helpful for beginners like me. Please upload more videos.
Thank you for the video! Very informative and helped me out a lot. I did have a question. After populating a form in IE, I tried to hit submit (via code and manually), but the form doesn't recognize that data has been populated. It has error validation that states the text boxes/combo boxes are empty. Do you know if there is a way to force the form to recognize the data? Thanks in advance!
Great effort man, however I have an issue with filling drop down lists on webpages using values in my excel sheet, and would like to ask as well about doing the whole thing in chrome instead of IE, what should I do to achieve that?
Awesome tutorial. Thanks for sharing!
Thanks so much for posting this video. Do you think it could be done in Chrome as well? or is VBA inherently better in working with IE? (Perhaps with SendKeys in Chrome?)
i have tried to run your code the exact why you have it in video but when i get to the IE.Document.All("btnK").click i get an error stating that object doesn't support this property or method any ideas?
what if the text fields are located in a pop up window? how to inspect the element? good job by the way
Good Job, Better if it could also be in chrome
Hi Juzer, it can! You can use Chrome, Firefox, IE, Edge, and even an invisible browser using a free tool. More info here: excelvbaisfun.com/complete-web-automation-with-excel-vba/
Thank you for another tutorial.
great tutorial
Thanks!!
Thank you!
You're welcome!
thank you for posting
You're very welcome! Thanks for the comment!
Thank you very much this helps a lot
Thank you so much for sharing
Excellent video my friend. The issue I am having specifically, is that the IE window I need to populate is a popup html window, and therefore, has no URL. I need to be able to do the same thing, using the Title of the html window instead of the URL. I am able to open, the Google Login page, and have it prefill my textboxes and submit. The real issue lies in that, the text boxes are in a popup window. Seems it would be easy enough, but not so much.
Hmmm, ok i'll work on this. Wish I had an example to work with, thoughts?? Dan
ExcelVbaIsFun It's hard for me to think of anything outside of the Service Desk software we use at work. What happens is, when we create a ticket, it opens in a popup form with several Textboxes on it. I am able to find the title of the htmlwindow, and the name of all of the Textboxes, but can't figure how to pass the variable (data in the cell) to the textbox by using the Title of the htmldoc. Check the link in the original message I sent you. If I come across any examples online, that I can supply you, I will most definitely send them your way. Thanks again.
yamuson08 I got your back. Found a solution. Will film and upload soon.
How would I use this code to choose from a drop down list?
Do you have the xls file to share?
Dear Sir
I have an excel spreadsheet with three column (A1=Employees names ,B1= Gross Salary , C1=Net Salary). I am looking for a code which automatically check employees name If employee name match than fill their gross salary and net salary.
Please help me
As you have written Createobject("InternetExplorer.Application") for opening in IE
what should I write for google chrome
vba works only for IE not for any other browser
Not really true, but I understand why you said that.
I cant get this to work... When I run the macro it stops at .document and says compile error: Invalid or unqualified reference. Everything I read online says to make sure your reference microsoft internet controls (shdocvw.dll). Well I did and its still not working. If found tones of other scripts to click a button but the pretty much all use .document and I have the same problem with all of them. Any ideas?
not work can help me?
we can work with hangout
No I'm sorry I cant use hangout on my work computer
This can be apply to access 2013?? How do i add the Fields
Hello, i can't use it, it's keep telling "error 91"
Help please!
It loads the webpage and pastes the value A1 into the search box but does not click on button "btnk"
Same happend to me
Thank you.
able to populate the search forum with my criteria...BUT..there is no click..thus click command is not functioning.
HELP!!
I am having the same problem. Maybe if we can find the name of the FORM that the button sits in and call it's "submit" event. Anyone find the name of the form?
Great Video !
Can someone give me a guide to how to build a macro with excel vba ? i dont know nothing about it .
Just start an Excel workbook with VBA macros enabled. Then search for help on Macros. But, I must say, "This is not something to play with if you know nothing about it". Macros can be very powerful and dangerous. Start with beginner videos here on TH-cam, but better, if you have some money. Buy good book on Excel VBA, or take a course on Udemy, or Udacity.
I get an error, 424 "Object required" but it only comes up every 10 runs but once i move the file to another computer it will happen every run. Any advice on how to solve? My code is borderline identical but mine fills in multiple text boxes in internet explorer:
Line that flags:
IE.Document.All("quote[origin]").Value = ThisWorkbook.Sheets("IO").Range("a1")
Hi Carl,
It could be that the element you're searching for is not yet loaded and may need to wait a second or two longer. Not sure exactly without testing of course.
Have an amazing day!
Thanks
Dan
what happens if ID and Name are the same when looking in inspect? this seems to be causing an error where I need to debug
Excelent!!!!
Cool! Thanks Michael
I know this video is very old, but I'm hoping someone will be able to answer me. This is exactly what I needed, however when I try to run it on a work computer I get the error: The object invoked has disconnected from its clients. Does anyone know how to fix this? I'm expected to have a program using this up and running asap
beautiful
Thank you, Vikram!!
can anyone pls tell me what are the other methods of Document object. because i want to search by different HTML tag(E.G. href, value etc)
I am not sure why it is not working I have attempted this several times but the text does not show up when I run this macro, everything else seems to work fine but I do receive an error message: Automation error the object invoked has disconnected from its clients. any suggestions would be greatly appreciated
You should make sure that you have internet explorer. And that you also have all the references. But it should work.
software that can fill the form automatically from excel sheet. Just submit should be manually.
Are used to program computers back in 1989 but I still can't login to a simple website today !I can't find anybody to help me I have plenty of money why is it very simple phone number I can call to get help with these issues
I would start at www.coursecheap.com or www.udemy.com to learn pc basics, my friend!
Had to us a "Sheet1" rather than "sheet1"
124367790