htmldoc

  1. M

    Not able to submit a HTML form

    Hi, The following code tries to populate the login form of my library account and submit the form. This code used to work fine until a few months ago. Now I am able to populate the account information but the submit action doesn't seem to work. On the other hand, if I stop the macro...
  2. M

    VBA Macro question

    Hi there, I need help on the below code: the way this should work is I will list shipment #'s on the excel sheet1 and by running the macro it open the web browser go to the website that I list, then it goes to a particular field and add 5%, this macro is currently working but it only works on...
  3. C

    Webpage data scraping help needed...

    Hi, Could someone tell me why the 1st code works but the 2nd doesn't? Both should print out "2" as the result yet only the first one does. Thanks for looking Sub get_commonShips() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument IE.Visible = True...
  4. L

    VBA to click on a button

    Hi! I want to login in a website, but first i have to select an option, and i'm not being successful. This is the website: https://servicosonline.cpfl.com.br/agencia-webapp/#/login And i want to select "cnpj". Can somebody help me? thanks The code that i am using: Dim htmlDoc As...
  5. E

    VBA auto login with Chrome

    I found and modified a code that will let me automatically log into the site I want but I can't figure out how to change from IE to Chrome. please help Sub wisdomone() Dim HTMLDoc As HTMLDocument Dim MyBrowser As InternetExplorer Dim Myhtml_Element As IHTMLElement Dim MyURL As String On Error...
  6. B

    Pulling specific data from the web to excel

    Hi guys, I have been using a search function box to pull specific data from a website which up until a few weeks ago has stopped working because the website name has changed and the coding does not work anymore. The website was called (.golflink.com.au) but is now called (.golf.org.au) from...
  7. J

    Input box

    Hi, I have the code below that I use to log in automatically into the website, how can i add input box in the code to ask me for the username and password and once i enter them to log in, thanks. here is the code: Sub login()Dim IE As Object Dim HTMLDoc As Object Dim objCollection As...
  8. B

    Log onto Website via VBA

    Hi I have the below code, it opens the website www.reece.com.au/myaccount/login, but does not fill in the email and password (Correct information on code has been removed for privacy) I assume it is not working as I have not referenced the correct name in HTML. I assume it is email and...
  9. D

    Signing into Gmail Account using VBA

    Hi There, I am trying to automate signing into Gmail account using VBA. I have the code, the issue I'm facing is it takes the username, hits the Next button but does not take the Password, throws an error. Tried the same code with facebook.com and it works fine. For the password field I'm using...
  10. F

    Web scraping exchange rates

    Hi im trying to make a small macro that fetch data from this site: Currency Exchange Table (US Dollar) - X-Rates however I have a basic error in my code before I can proceed. Option Explicit Sub Exchangerates() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As New...

Some videos you may like

This Week's Hot Topics

Top