internet automation

  1. M

    VBA macro copy/paste text from Internet Explorer

    Hello, I'm hoping someone can help me as I've not done this before. I've written macros but never any that interact with Internet Explorer. I'm trying to automate a task that will allow the user to run the macro to copy specific text from an open browser window and paste the values into...
  2. A

    Will a kind soul help to provide a vba solution to insert text into webpage textbox

    Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...
  3. S

    Excel respond to a web DOM event via VBA

    I have an Excel document. It creates an Internet Explorer instance and navigates to a URL. *I am testing this with duckduckgo* I want to be able to respond, within vba, to a button being clicked on the website. `html.querySelector("#search_button_homepage")` finds the input element, how can I...
  4. S

    VBA Script to select the file and upload on IE

    Hi All i am trying to create a script to upload a wallpaper after signing. So far got through this after several attempts, your help is greatly appreciated. Source: Upload Upload current code Dim HTMLDoc As HTMLDocumentDim MyBrowser As InternetExplorer Sub VCW() Dim MyHTML_Element...
  5. M

    Internet Automation Retrieving DIV class results

    Hi everyone, I am running into issues retrieving data back into excel after I automate the click on the web page. The html code that I believe has the results is[HTML]div class="zipcode-result-address"> 123...
  6. M

    DOM IE Automation Error

    I am attempting to set up some IE automation; however, I am running into an error where it states that the object is not supported. Here is where the code is throwing an error .document.GetElementsByName("byaddress").Click I might be calling the wrong element. The a title="byaddress" Here is...
  7. C

    VBA Run-time error '91': Object variable or With block variable not set Internet Explorer Controls

    Hello, I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...
  8. D

    IE Automation using Excel VBA (navigation issue)

    Hello, please help I'm trying to create macro which will pull data from site I was using this code for others projects. However, It's not working with http://www.phila.gov/water/swmap/ I think the problem is in Set Element = .document.getElementsByName("searchText") Maybe I didn't choose...
  9. A

    Automation - Clicking button in IE

    Hi, I've seen this same question posted on this forum as an avid viewer but I can't seem to relate any of the answers to my HTML so I'm looking for some help. Below is my HTML. <img class="hand" type="image" name="addNewJobImage" src="images/btn_add.gif" alt="Add Job" *******="addJob('new')...
  10. H

    Extract text from multiple sites on a Mac

    Hi all - first time poster, long time follower here! I have a website https://www.top10erp.org/erp-software-comparison-distribution-industry-164 that contains a table with a load of links. Each link takes you to a different (non-indexable) page. I'd like to copy the body of text from each page...
  11. M

    Excel VBA with Internet Explorer help- fill in fields and export data

    So I apologize if there is a comprehensive guide to this somewhere.. I have scoured the internet and these forums searching for everything I can, but I cannot find what I'm looking for. I am not new to macros at all, but I am unfamiliar with using them to automate IE. Essentially what I need...
  12. R

    Excel VBA Open IE Select Option Dropdown Menu Copy HTML to Text

    Hi guys So far, I have managed to open IE and click the dropdown menu. But I am having a hard time selecting any of the options in the drop down list. Can anyone help? Please find the code below. Rgds Sub OpenWebSelectClickSaveHtmlFile()Dim URL As String URL =...
  13. T

    VBA IE input field fill doesn't work first try, always works second try

    Hello, I have a vba code attached to a button to open a webpage, fill an input field with data from the workbook, and click the submit button. Upon opening the workbook, click the button opens the webpage, but that's it. If you go back and click the button again, it loads the page again, and...
  14. M

    Input Data to a webpage which is already open.

    Hi, I'm looking for codes to get access to a webpage which is already open. I don't want vba to open the url for me as user will manually login into that. Once webpage is ready, vba will input data from excel to webpage. I can manage the codes to feed data but not sure of how to get in to the...
  15. V

    VBA Internet Automation

    Hi, I am trying to use VBA to log into a website and then complete several actions. So far I managed to log into the page, but I am unable to then click a button/link in a sub-menu. I would be really grateful for any advice on how to execute the link in this sub-menu. Thanks a lot! My VBA...
  16. V

    Internet Explorer VBA Automation

    Hi, I am trying to open a website and log into it using VBA. The probelm I run into is that the username and password are only filled in "superficially". Hence when the VBA code clicks the login button it asks me to enter a username and password. When I click into the username and password...
  17. J

    Excel VBA: Click javascript anchor on webpage through IE and save generated file

    Greetings, I've been reading this forum for a couple years now, but this is my first time posting a question. As they say on the radio call-in shows, "First-time, Long-time." While I've grown leaps and bounds in my general excel macro writing, I am just beginning to delve into automating...
  18. B

    Automating already open IE Window

    Hello - first post here :) I'm a VBA newbie and haven't really started with the easiest project! I'm trying to pull some data out of a website using a VBA macro and would like it to use an existing IE window (as it requires user intevention to find the correct page in the first place - this...
  19. K

    Internet Explorer w/ iframes Automation Macro

    hi all, I’m trying to figure out how to have a macro bring up a website (an internal document website) locate the correct frame uncheck a box, fill in a field with a cell value (from A2) click submit, jump to the next frame within the same website and click a link. my main problem is it looks...
  20. B

    VBA IE automation checkbox and submit issues

    The code below works for selecting the checkbox when I am already logged in (in this scenario the log in screen never shows up when a new ie is created), but when I am not logged in the code works for logging me in, but then will not select the checkbox once logged in. In both scenarios I am...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top