ele

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!" />...

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...

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"...

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...

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...

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...

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...

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 =...

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...

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...

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...