Wow really well explained code line by line….Every thought of doing a similar video for Ms Access users? How to get a form’s WebBrowser control page contents passed to a table
Million thanks for this great and clear tutorial. When I searched IE automation I was looking for automating google speech recognition in IE, but I discovered that IE does not support the API and it is only supported by google chrome. Do you have any idea on how to automate this using IE?
Help please. I run the code but it doesn't print the links and text content to Excel (basically what's in the For Each loop) but it does everything else. I ran the code line by line and it does print to Excel though. Is there an issue with the 2nd "wait to load" code after clicking search?
Update: It is a loading time issue and had to delay the For Each loop from running too quickly as the 2nd "time out" code isn't doing its job. Can anyone else confirm this? Note: I'm not a time traveler and am indeed doing this in 2020.
@@rogerh2694 I dont know the solution yet but this is some IE security thing... same for me ... stackoverflow.com/questions/12965032/controlling-internet-explorer-local-intranet-using-excel-vba
Hi I am trying to get data from .Jason file. Do you have any idea how can I get the same? As soon as I open the link in IE it offers to download it. Any idea how to do the same on other browsers? Thank you .
It's a great video, but, what if when I search the ID of the cell at any browser (EI, Mozilla or Chrome), there is not information about it, just found " "? Regards.
How do I select an option from a dropdown menu and update the page. Using HTMLDoc.getElementById("xyz").Value = "dropdown_option" I successfully get the option. But, the website doesn't update? e.g. filling up other fields. I believe some javascript needs to be run. How can i fix this using VBA? :-)
Hi your video helped a lot. I am trying to automate a repetitive task by clicking on a button which is actually not a button and it is an image. Below is the HTML code.. Please help.
i have 1000s of company names in excel and want to search thier websites and also exctract email ids from the respective websites automatically using Excel VBA
I'm getting an error message " Object doesn't support this property or method. The code stops in this line: For Each aEle In objIE.document.getElementsByClassName("result__a") How would I debug this? Thanks
Hi can you guys tell me a way to click(not being mouse setcursorpos, sendekeys, or ie.document...click/submit, get..id, tagname, name) in a button considarating you're already manipulating Ie, i've tried these methods and nothing
I've tried to ask in stack overflow, the title off the question is "Macro Vba - ie...click, not working button" if someone wants to help me i would be very glad :D, in the question i've specified the code of the button and the many methods i tried
I know this comment is a year old, but I'm having the same problem on my work computers. Do you know at what part you would get the error? I'm able to pull up the website fine, but when I try to populate a box I get that error. Was this the same for you?
Hello Sir, I refer to this web site www.familycomputerclub.com/how-to-login-automatically-into-website-using-excel-vba.html and would really appreciate if you can answer my question. How can I transfer that auto web login script from Excel VBA to a VBScript Script File (.vbs) and make it functional? Also how do I save Excel VBA - when I click save it has only one option save FUNCRES.XLAM and there is no option to save anything else there? Thank you!
Great video. It is rare to see this kind of VBA tutorial, more advanced.
Excellent tutorial! It helped me to drammatically automate data collecting. Thanks!
AWSOME video, really helped to program auto-bot for "Travian"
very usefull information. It is good for contetnt managers.
Very good video, must give it a try, and modify for my particular need.
Wow really well explained code line by line….Every thought of doing a similar video for Ms Access users? How to get a form’s WebBrowser control page contents passed to a table
Million thanks for this great and clear tutorial. When I searched IE automation I was looking for automating google speech recognition in IE, but I discovered that IE does not support the API and it is only supported by google chrome. Do you have any idea on how to automate this using IE?
Shady i have the same problem
Great video! Thanks a lot from Russia with love. :)
Is that what they say?
Help please. I run the code but it doesn't print the links and text content to Excel (basically what's in the For Each loop) but it does everything else. I ran the code line by line and it does print to Excel though. Is there an issue with the 2nd "wait to load" code after clicking search?
Update: It is a loading time issue and had to delay the For Each loop from running too quickly as the 2nd "time out" code isn't doing its job. Can anyone else confirm this? Note: I'm not a time traveler and am indeed doing this in 2020.
@@rogerh2694 I dont know the solution yet but this is some IE security thing... same for me ... stackoverflow.com/questions/12965032/controlling-internet-explorer-local-intranet-using-excel-vba
Great video. I need to learn this and this video looks like a great start.
+Brad N
Thanks Brad!
Really useful and well-explained, thanks.
Very well explained tutorial, great work
Hi I am trying to get data from .Jason file. Do you have any idea how can I get the same? As soon as I open the link in IE it offers to download it. Any idea how to do the same on other browsers? Thank you .
Great !!! Automates a big job
hi is that possible to automate the https website...my friends says it's impossible to that with secured website...
It's a great video, but, what if when I search the ID of the cell at any browser (EI, Mozilla or Chrome), there is not information about it, just found " "? Regards.
how can i do not open IE but chrome? same question
Same question here, try to export data from Chrome
I need your help ! I have a sheet but I can't click in the link, because it's in Java. Do you know how to do ?
can you please tell the code to click any link under class result__a
How do I select an option from a dropdown menu and update the page.
Using HTMLDoc.getElementById("xyz").Value = "dropdown_option" I successfully get the option. But, the website doesn't update? e.g. filling up other fields.
I believe some javascript needs to be run.
How can i fix this using VBA? :-)
thank you so much! really usefull video
the button that i work with only has name .
how can i click this button ?
Hi, I´m a beginner. What should I do when the search text box doesn´t have a ID?
Add an "n"
Hi your video helped a lot. I am trying to automate a repetitive task by clicking on a button which is actually not a button and it is an image. Below is the HTML code.. Please help.
I'm trying to click. A button on a web site but am unable to do so
The HTML code is
Take that space off between on click listener...
And add quotes after () and ; is not necessary
i have 1000s of company names in excel and want to search thier websites and also exctract email ids from the respective websites automatically using Excel VBA
I'm getting an error message " Object doesn't support this property or method. The code stops in this line: For Each aEle In objIE.document.getElementsByClassName("result__a")
How would I debug this? Thanks
For this should I update IE or Excel?
Hi can you guys tell me a way to click(not being mouse setcursorpos, sendekeys, or ie.document...click/submit, get..id, tagname, name) in a button considarating you're already manipulating Ie, i've tried these methods and nothing
I've tried to ask in stack overflow, the title off the question is "Macro Vba - ie...click, not working button" if someone wants to help me i would be very glad :D, in the question i've specified the code of the button and the many methods i tried
have you tried .submit?
I get "The object invoked has disconnected from its clients" error or "Automation Error"I will keep playing with it.
I was able to get it to work by changing Internet Explorer from" InternetExplorer" to "InternetExplorerMedium"
This apparently happens because I was at work and it defaults as low priority and it doesn't find what it wants.
I know this comment is a year old, but I'm having the same problem on my work computers. Do you know at what part you would get the error? I'm able to pull up the website fine, but when I try to populate a box I get that error. Was this the same for you?
this website does not work. Is there an up to date website to access?
oops - cloudflare issue. Fixed. Thanks!
this website does not work
👌
But video is blurred 😔
Hi... Do you have Facebook account
Hello Sir, I refer to this web site www.familycomputerclub.com/how-to-login-automatically-into-website-using-excel-vba.html and would really appreciate if you can answer my question. How can I transfer that auto web login script from Excel VBA to a VBScript Script File (.vbs) and make it functional? Also how do I save Excel VBA - when I click save it has only one option save FUNCRES.XLAM and there is no option to save anything else there? Thank you!
sir please send me same module for Firefox on mail
Fire Fucks )))))