Video size: 1280 X 720853 X 480640 X 360
Show player controls
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?
Would it be possible to get a download link?
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.
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?
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?
Must certain References be checked in Tools > references?
software that can fill the form automatically from excel sheet. Just submit should be manually.
Mohit Mavani submit can also be done byIe.documents.getelementid(“button”).click
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
Hi Alex,can you please tell me, how to call date picker to set date?
how do you fill a text box in an already opened web page.?
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 ObjectSet objIE = CreateObject("InternetExplorer.Application")Dim webSite As StringwebSite = "www.google.com/"With objIE .Visible = True .navigate webSite Do While .Busy Or .ReadyState 4 DoEvents Loop objIE.Document.getElementByID("lst-ib").Value = "This isthe block of sample text that I am sending to a field on a webpage" End WithEnd Sub
Hi Alex,I have an HTML code like the one below. How can I create the macro to fill me the entity, username and the pass.Thank you! Secure Sign In... Forgot your password?
hi Alex , it was great , i want to do it . thank you
Alex can someone detect if i am using automation on the website?
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: ru-clip.net/p/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU
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?
is there any web side to copy of your code to use directly ?
Hi Alex, Any chance you can direct me to the code you use to select from online drop down lists?
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"
my friend if i need firefox only change "internetexplorer.aplication" by "firefox.aplication" and ready?? i need fillling a web form but i need firefox and every field must click before to process..... i wait your answer thx...
Excellent. Very well explained. Thank you!
Hi Alex,I like your videos, the reason I'm leaving this comment is that I want to ask you if you know how to fill the webforms with data from Collums and cells. something like this : A1:A10 - First name , B1:B10 - Last Name , C1:C10 -Emails , D1:D10 - Upload Photo and so on.Can you help me please? :)Thanks a lot!
Really beneficial. Thank you for your help, Sir.
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?
@Alex Cantu 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.
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: ru-clip.net/p/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVU
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!
Alex its seems not complete, can you please tell how to press button after it ?
@Alex Cantu Thank you Alex, I will go through this link, will let you know if some doubt remain ... Thanks again :)
@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: ru-clip.net/p/PL6OYc4rwKjcOu3UL7LYpvO_S2waYO-hVUThat 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!
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.
Could you please give more background? What are you trying to accomplish?
Alex, thanks for the video, it is great. I now know what my new hobby will be in the next weeks (learning more about this), YOU DE MAN, Frank
Thank you for your feedback Frankie. Keep it up!
Yeps! Works fine! Super tutorials.. Thank you very much!
Can i make it check an uncheked-checkbox?
automatic file upload. :) thanks alot
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.
please,how i can do the same program with visual C++
ok next bit of awesome: I tried doing what you just posted with Call IE.Document.GetElementByID("Prefill").Clickbased on the following bit of page source: input type="button" value="Prefill" onclick="prefill()"Yet it's not working. Any thoughts?
Yes. That was it. You The Man.
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
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
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.