internet explorer

Sub IE_Load_PrintScreen() ' IE and OutLook Dim NorryLink As String ' Link to copy Print Screen NorryLink = "Home - County of Northumberland" & Sheets("Tax Cert Bill").Range("B17").Value Dim IE As Object Dim hwnd As Long, IECaption As String Set IE =...

Hi. So I have this web scrape code that pulls data from a work website using Internet Explorer. Works fine. However, when there is a lot of data it is slow. So I have been trying to convert it using Get request since it seems to be quicker. However, it pulls nothing. Running the code step by...

I have a code that opens various web pages, copies (Select-All) the information on the web page and then pastes the information into an excel using match destination formatting to ensure that the worksheet replicates the column formatting within the web pages. The code below has worked for...

Hi, I am trying to click the export button by ID ("exportRpt") but nothing happen in the IE. Is there anything that I have missed? I have written a code to loop through each IE and find the new IE that I am going to work with. here is my Macro code: Sub Third_Level() Dim TWB As...

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

I need some help from the smart guys here on the site. The code snippet below don't give any errors and it looks that it works fine, but the TD element collection stays empty and the innerText is empty too. That while the data are showing in a visual browser as You can see in the image below...

Hi. I am trying to use my VBA code to click a button on an IE Web page. I have tried various lines of code but keep getting the Object Error 424. Below is the web page code detailing the button.... <td id="cellInvestment </br>Choice" align="left" name="cellInvestment </br>Choice"...

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

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

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

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

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

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

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

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

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?

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

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

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

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