I am trying to automate excel to enter addresses into google maps so the user can get the distance and time of travel from point A to B. Right now, I only know about internet explorer object from what you have posted in your channel. Hopefully more videos can help me know more of its functionality.
Hi Alex - is there a way to read the data from xls or csv file... & loop it? Objective is to do more than one so it loops till end of file and we can do batch creations...
Thanks. The code works for me for entering data. But the last thing I need to know is how to click the Submit/Enter button. I cannot figure this out after multiple google searches. It seems like I should be able to identify the button and send a 'click' command, or something similar. How would you end your code by clicking the 'send' button? Thanks
Hi, I need to do UPLOAD an image bij VBA in a website with that possibility. Is there any extended explanation for that with a general code witch I can follow? thanks.
Dear Sir, what is the code for "waiting till webpage completely loads in chrome using excel vba" as it is "ie.readystate = readystate_complete" in internet explorer
Hi Alex. I was wondering if you can have a userform in excel fill it out and then click a button and it can navigate to a site and fill it in with the data you have inputed in the excel userform?
My vba works to fill the online first page, from the data in excel... But when it clicks on submit, a new page loads and which requires more data to be filled in continuation of first page information...My issue is how to keep the page active So that it keeps on getting the data from the excel sheet... In continuation... Kindly suggest
I'm using the same website as you in this video and I'm only using the code up through the for loop to test things out and the code is not working for me. It never finds the phrase "Sign Up". How I know this is I put msgbox's through the for loop and if statement. The msgbox in the If statement never executes because the statement must always be false. Do you have an idea why it never finds the text "Sign Up"
Hello, i'm trying to do something similar but the form that i want to fill out has drop down fields, instead of free form text fields is there a way to do that?
What happens if you go through all the elements and it doesn't find the "Sign Up" hyper link, are you stuck in an endless loop? Is there a "condition not satisfied" state to exist the for loop, and end subroutine with an error message?
ok next bit of awesome: I tried doing what you just posted with Call IE.Document.GetElementByID("Prefill").Click based on the following bit of page source: input type="button" value="Prefill" onclick="prefill()" Yet it's not working. Any thoughts?
This video is truely informative. Thank you sir. Can we automate to upload a pdf document to a specific website using VBA sir ?? if so please upload a video on that, it will really help us a lot. Thanks in advance, Prakash GS
Trying to pass the contents of a cell, and I've got SetAttribute("value", ActiveSheet.Range("c2").Select) however i'm getting true as my output. instead of the result of the formula in the cell. Any Help?
Great video, did a search for something I need to automate and found this, could you start putting the code you use in the comments or a link to a pastebin? :p
Atul Mandal Got it. There is a lot to learn then, and you should be familiar with the DOM (Document Object Model). I would recommend watching this series first: th-cam.com/play/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU.html That will take about 3 hours of your life. :) but save you months, possibly even years of learning from the text books. If you have questions after, please let me know. I answer where and when I can. Thank you again!
Hello! This video was not part of a series. If you are looking for a video series on VBA and the InternetExplorer.Application object, try this series: th-cam.com/play/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU.html
Alex....I need to accomplish the identical result (below), but have to do it in chrome. Any help would be greatly appreciated. Private Sub SendsTextToFieldUsingIE_Click() Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") Dim webSite As String webSite = "www.google.com/" With objIE .Visible = True .navigate webSite Do While .Busy Or .ReadyState 4 DoEvents Loop objIE.Document.getElementByID("lst-ib").Value = "This is the block of sample text that I am sending to a field on a webpage" End With End Sub
Thank you, this knowledge is helpful to me.
Excellent. Very well explained. Thank you!
Hello Mr. Dinesh... I hope you fine... Just wanna say you r a very great person
I am trying to automate excel to enter addresses into google maps so the user can get the distance and time of travel from point A to B. Right now, I only know about internet explorer object from what you have posted in your channel. Hopefully more videos can help me know more of its functionality.
Sir... thanks a lot!!! You explain really good, I don't know much about HTML or those codes, but I did what I wanted to do.
This is called maths😊
hi Alex , it was great , i want to do it . thank you
Hi Alex - is there a way to read the data from xls or csv file... & loop it? Objective is to do more than one so it loops till end of file and we can do batch creations...
Thanks. The code works for me for entering data. But the last thing I need to know is how to click the Submit/Enter button. I cannot figure this out after multiple google searches. It seems like I should be able to identify the button and send a 'click' command, or something similar. How would you end your code by clicking the 'send' button? Thanks
Must certain References be checked in Tools > references?
Hi, I need to do UPLOAD an image bij VBA in a website with that possibility. Is there any extended explanation for that with a general code witch I can follow? thanks.
Dear Sir, what is the code for "waiting till webpage completely loads in chrome using excel vba" as it is "ie.readystate = readystate_complete" in internet explorer
Alex can someone detect if i am using automation on the website?
Really beneficial. Thank you for your help, Sir.
Great. But one important thing is missing. How to click submit button then read displayed data from the webpage and save that in excel sheet?
Yeps! Works fine! Super tutorials.. Thank you very much!
Hi Alex. I was wondering if you can have a userform in excel fill it out and then click a button and it can navigate to a site and fill it in with the data you have inputed in the excel userform?
+kupkel711 Of course, check out this series: th-cam.com/play/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU.html
Hi Alex,
can you please tell me, how to call date picker to set date?
My vba works to fill the online first page, from the data in excel... But when it clicks on submit, a new page loads and which requires more data to be filled in continuation of first page information...My issue is how to keep the page active
So that it keeps on getting the data from the excel sheet... In continuation... Kindly suggest
I'm using the same website as you in this video and I'm only using the code up through the for loop to test things out and the code is not working for me. It never finds the phrase "Sign Up". How I know this is I put msgbox's through the for loop and if statement. The msgbox in the If statement never executes because the statement must always be false. Do you have an idea why it never finds the text "Sign Up"
is there any web side to copy of your code to use directly ?
Hello, i'm trying to do something similar but the form that i want to fill out has drop down fields, instead of free form text fields is there a way to do that?
Hi Alex, Any chance you can direct me to the code you use to select from online drop down lists?
Yes. That was it. You The Man.
What happens if you go through all the elements and it doesn't find the "Sign Up" hyper link, are you stuck in an endless loop? Is there a "condition not satisfied" state to exist the for loop, and end subroutine with an error message?
May you provide the code in the description?
When I do this on my site, it was change the Value under Inspect Element, but the text box itself won't change. Is there a way around this?
ok next bit of awesome:
I tried doing what you just posted with
Call IE.Document.GetElementByID("Prefill").Click
based on the following bit of page source:
input type="button" value="Prefill" onclick="prefill()"
Yet it's not working. Any thoughts?
Thanks again.
This video is truely informative. Thank you sir.
Can we automate to upload a pdf document to a specific website using VBA sir ??
if so please upload a video on that, it will really help us a lot.
Thanks in advance,
Prakash GS
Trying to pass the contents of a cell, and I've got
SetAttribute("value", ActiveSheet.Range("c2").Select)
however i'm getting true as my output. instead of the result of the formula in the cell. Any Help?
Great video, did a search for something I need to automate and found this, could you start putting the code you use in the comments or a link to a pastebin? :p
Can i make it check an uncheked-checkbox?
Would it be possible to get a download link?
how do you fill a text box in an already opened web page.?
Alex its seems not complete, can you please tell how to press button after it ?
Could you please give more background? What are you trying to accomplish?
Actually I need to submit roll number kind of data and save it by clicking button. Then grab the output data from a Web page.
Atul Mandal Got it. There is a lot to learn then, and you should be familiar with the DOM (Document Object Model). I would recommend watching this series first: th-cam.com/play/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU.html
That will take about 3 hours of your life. :) but save you months, possibly even years of learning from the text books. If you have questions after, please let me know. I answer where and when I can. Thank you again!
***** Thank you Alex, I will go through this link, will let you know if some doubt remain ... Thanks again :)
please,how i can do the same program with visual C++
automatic file upload. :) thanks alot
software that can fill the form automatically from excel sheet. Just submit should be manually.
Mohit Mavani submit can also be done by
Ie.documents.getelementid(“button”).click
It is hard to follow your video series. After I watch this video, which one should I go to? and Where is the previous one?
Hello! This video was not part of a series. If you are looking for a video series on VBA and the InternetExplorer.Application object, try this series: th-cam.com/play/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU.html
***** thx... ur videos are great. I use the VBA in excel spreadsheet a lot, but I rarely use with the web. I would love to see more of these videos.
Can you paste the code in about?
Hi - Don't have the code anymore. But if you play the video in 720P, you should be able to see the code. Thank you for watching!
*which:)
Alex....I need to accomplish the identical result (below), but have to do it in chrome. Any help would be greatly appreciated.
Private Sub SendsTextToFieldUsingIE_Click()
Dim objIE As Object
Set objIE = CreateObject("InternetExplorer.Application")
Dim webSite As String
webSite = "www.google.com/"
With objIE
.Visible = True
.navigate webSite
Do While .Busy Or .ReadyState
4
DoEvents
Loop
objIE.Document.getElementByID("lst-ib").Value = "This is
the block of sample text that I am sending to a field on a webpage"
End With
End Sub