internet explorer

  1. L

    Please advise the codes I used

    Hi I got the below vba code from this site. The code will automatically open the site in IE(will be using different url) and will import files as well. When I ran this code,it did not work due to incorrect elementsTagName and maybe InputType as well. What should be the correct codes? I am not...
  2. T

    Excel VBA Runtime '91' error during lookup in Internet Explorer

    Good day. I am trying to lookup some Warranty Expiration dates via Internet Explorer and return the results to and Excel spreadsheet. Currently the code is very rudimentary. I have not yet added to code to read serial number from the worksheet or write the results back to the spreadsheet. I just...
  3. P

    Yahoo finance browser version error preventing web scraping

    I have been scraping data from Yahoo Finance pages for years with VBA code in Excel (now in Excel 2010) by opening an IE window and working with the data from the document HTML. Aside from adjusting for Y.F. making changes often I've been able to get everything I need either from stock quote...
  4. M

    Submitted forms via IE

    Hi all, I am trying to automate a number of forms we need to submit on a weekly basis with the same details. I have tried writing a VBA code for this however I get an error once i read the first elementbyid. Sub SubmitSpark()Dim IE As Object Application.ScreenUpdating = False Set IE =...
  5. K

    Website not updating after inserting drop down option via VBA

    I've tired a lot of different approaches and still have not figured out any way to overcome the issue. When use the .selectedindex = 10, the option appears just like i wont it to, but the date range boxes will not appear after i've picked the option. ive tired .focus .fireevents .click and many...
  6. A

    Help Scrolling an IE modal

    First off, I appreciate all of your time in reviewing and potentially responding to my inquiry. I have a webpage that loads a modal that is longer than the page displays requiring me to scroll down to get the second screenshot. I have not been able to programmatically scroll the modal despite...
  7. F

    Excel-IE Automation w/VBA on Dynamic Tables

    Good Morning, I’m hoping that some kind soul out there can help me with a roadblock I’ve encountered in my quest to manipulate a website with VBA. I am using MS Excel 2010 and Internet Explorer 11.0.56. I’m somewhat comfortable with VBA but have never used it to navigate to a website, enter...
  8. C

    VBA Internet Controls Log In to Website

    I am trying to make an excel macro log in to a website and get stuck at trying to tell the macro to click Sign In. The website URL is https://fed.transplace.com/adfs/ls/IdpInitiatedSignon.aspx?loginToRp=https://tms.transplace.com/ Could someone tell me the HTML element that I will need to use...
  9. B

    web crawler won't crawl

    Hi All, I wrote this crawler 6 months ago and now it gives me error message. Dim IE as InternetExplorer "user defined type not defined" error, I use the same exact line in another excel book. Any ideas?
  10. K

    Internet Explorer webpage - login and password

    Hello, I have a website, for which I would like to write a macro for providing username and password, and log in with specific credentials. The website is written in JavaScript language. I am using MS Excel 2016, IE v11. Here is my current code (I needed to provide "xxx" where necessary): Sub...
  11. E

    VBA Help: Extracting website information with Internet Explorer

    Hi all, I'm a VBA rookie and I have only just begun my dive into this deep realm of new learnings due to the limitation of formulas. I’m attempting to use VBA to open internet explorer, click a search button, then extract the tabled information presented. The website is...
  12. K

    Internet Explorer - log in to a webpage

    Hello, I try to write a macro for: 1) Opening a certain webpage in Interner Explorer 11 (I am using 64-Bit MS Excel 2016) 2) Going to specific fields within a website 3) Providing "User ID" and "Password" values 4) Clicking "Login" button I am a VBA beginner :) Thank you in advnce for any...
  13. B

    vba internet explorer click button works, but doesn`t take my inputs

    Intro> I'm new to vba for ie, I've been searching in many forums for days, but I still couldn't find someone with the same problem as me. That's why I'm creating this new thread. Would someone please help? My goal> I want to automate my searches for flight tickets in skyscanner . com More...
  14. M

    VBA Radio Button Selection in IE

    I am trying to select a drop down radio button in Internet Explorer but keep receiving the "Run-time error '424': Object Required" error. Here is the code I am using Sub Select_Cartons() ' Set a reference to 'Microsoft Internet Controls' under the VBA Tools\References menu Dim IE As...
  15. G

    How to navigate through multiple links on website using vba internet explorer

    I want to select options on multiple pages using vba internet explorer and i am able to open multiple tabs and multiple links using vba but only able to navigate on first page. Please check the coding given below for your reference:- <code>Sub mmtlink2() Dim IE As New SHDocVw.InternetExplorer...
  16. M

    Paramaterized Power Query/PowerPivot data import problem

    Hi I have created a powerpivot report in Excel 2016 that imports data from several parameterized SQL Stored Procedures. The purpose it to allow individual users to only view relevant data; the model is quite data heavy so I want to limit the number of records at source. I have created 2...
  17. Ombir

    Exccute Javascript in IE

    Hi, I want to click on button on a webpage which doesn't contains button tag. I think it is associated with javascript code execution. Below is the Html Code of complete webpage. <!DOCTYPE html> <html> <head> ****** http-equiv="Content-Type" content="text/html; charset=utf-8" /> ******...
  18. P

    Click a link in the internet

    Hello all, I`m trying to click a link in Internet Explorer using VBA. Tried a lot of things I could think of, but nothing seems to work. I tried everything I could think of or find in the internet, but nothing worked so far. I know that normal .Click is not working in this website, so I use...
  19. B

    Need help opening IE browser and searching Google from Excel

    I created a macro in VBA to open an Internet Explorer window, go to Google, and search Google based on what is the the active cell when you trigger the macro. The macro also Maximizes the IE browser window. The problem is that the macro does not run correctly every time. Often it will go to...
  20. C

    IE automation: saving file from website

    Hello, Long time creeper, first time poster! I've seen similar questions about IE automation on this board and need help adapting code I have found to my situation. I have code that currently opens IE, navigates to the desired URL, interacts with the form by clicking checkboxes that fit my...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top