ele

  1. N

    VBA to click button to login to website

    Hi I'm trying to automate a log in for a website to put live pricing into excel. I can get it to fill in the username and password but the coding to click the 'Go' button doesn't work. The script for the buttin under 'inspect element' is: <input class="weebutton" type="submit" value="GO!" />...
  2. E

    VBA to google search based on cell value

    Hello, I am having trouble coming up with a macro that searches google based on a cell value, then returns the Google review score. I tried modifying the below code to suit my needs but keep getting a Run-time error 91 Object variable or With block variable not set. Any help would be greatly...
  3. G

    Excel vba to select item from dropdown on webpage

    I'm having trouble getting the syntax right to select an item from a dropdown on a webpage. It's to select gender. I think it's something to do with it using javascript. When I do Inspect element on the dropdown I get the following: <table width="100%" style="z-index: auto;" cellspacing="0"...
  4. D

    Export sheet collection to pdf

    Greetings, I need some assistance with sheet collections. I have a large spreadsheet that our designers copy onto each job file and use. The first 103 sheets do not get printed or exported to pdf. We only send out the new generated pages. I have written code to select all sheets from sheet #104...
  5. J

    VBA - HTML add data below previous

    Hello, my code here works it loops through what is in column A of sheet 2, but it does not add that data below the previous data pull. How can I adapt the code below to make that work please? Many thanks. Sub Cards() Dim IE As InternetExplorer Set IE = New InternetExplorer Dim Dline...
  6. J

    VBA - HTML Pull Data

    The following code is only pulling 1 result when there should be 6 results, can anyone spot where the code is overwriting rather than adding to it? Many thanks. Sub Meeting_List() Dim IE As InternetExplorer Set IE = New InternetExplorer Dim ElementCol As Object Dim Link As Object...
  7. S

    Screen scraping from Internet after submit (VBA)

    Hello, I'm trying to retrieve information from Internet. I'm opening the site, filling in a condition and press the button Deal. So far it works. But then I'm trying to retrieve the information displayed on the website into VBA and sometimes that works and sometimes it doesn't. It seems...
  8. S

    Scraping the web

    Who can help me, please? I'm getting crazy as the code underneath sometimes works and sometimes doesn't. I haven't got a clue when it is working and when it doensn't ... Function pbnInternet(Condition) Dim objIE As Object, ele As Object Dim pos As Integer Set objIE =...
  9. R

    How to retrieve data from a website using VBA

    I have the following code: Sub RetrieveData() 'dimension (set aside memory for) our variables Dim objIE As InternetExplorer Dim ele As Object Dim y As Integer 'start a new browser instance Set objIE = New InternetExplorer 'make browser visible objIE.Visible...
  10. M

    Going from IE to Google Chrome.

    I am trying to change my code from IE to Google Chrome and I am getting stuck on the ready state. Option Explicit Const MyUserName As String = "ABCOFA" Const MyPassword As String = "******" Const dayfrom As String = "12/01/2015" Const READYSTATE_COMPLETE As Integer = 4 Dim chromePath As...
  11. M

    Click button not working

    I am trying to click a button on a website. My code works on three button but not the last for some reason it is the last next that does not work. Public Sub Billing() Set objie = CreateObject("InternetExplorer.Application") With objie .Visible = True .Silent = True...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top