ie automation

  1. W

    VBA IE Automation Logon, Navigate multiple buttons and then scrape data back into excel

    Hello All, I am having trouble with some VBA to scrape data. I have a website (FltPlan.com) that I need to login to (I have managed to find multiple sources of code to do this and it seems pretty straight forward. Once logged in I need to navigate to a specific page on the site to scrape...
  2. P

    IE VBA Web Scrapping Table extract issue

    Hello Guys, i have below code that copy table on current webpage but when i change that page it not getting new table. note both the tables have same format, with little change in content, Dim i As SHDocVw.InternetExplorer Set i = New InternetExplorer Dim clipboard As MSForms.DataObject...
  3. P

    Web scrapping with JAVA based website

    Hello all, current issue is that i am working on one website where it run JAVA script to load data and i need to copy that data once it complete loading. now loading time is not fixed so my code run before it completes loading. do some event and readystate=4 is not working on this. is there...
  4. N

    Internet Explorer event DocumentComplete does not fire

    Hello folks I am struggling to use events with IE automation from an Excel workbook, to feed some data from a web server into Excel. The queried page takes very long, and I would like the user to initiate the query with IE to obtain the data, then once the web page is complete, return control...
  5. M

    Excel VBA - IE Automation Form Trouble

    I'm using Excel VBA to control IE - more specifically a javascript multi-page form with several text boxes and other elements such as drop down boxes. The drop-down boxes and multi-select boxes have an "onchange" event that I am successfully firing. And I am able to fill the text boxes out...
  6. Y

    vba HTML Frames automating IE

    Hi All! I am trying to automate opening a new IE window, navigating to an intranet site (company site), and then begin selecting from a drop down list. The drop down list then triggers a javascript code "onchange" The problem is the list is in another frame within the site, and I am not sure...
  7. T

    IE automation after recent IE updates

    The recent updates to IE11 got rid of a bunch of useful stuff for VBA, like document.all and execScript. Is anyone else having issues as a result of the update? For example, I had this line that worked on multiple versions of IE, including IE11 until the recent update...
  8. P

    How to access buttons in tables with internet Explorer through VBA (Excel)

    Hi All, I have a website page which has table formatted buttons to download data with it. below is the source code of website. I have kept the source code of website in this link. Sorry I was not able to post it in forum thread (it is converting code into webpage ). Let me know if you still...
  9. M

    IE Automation Error: Permission Denied

    I need to be able to automate data scraping of property assessment data for work, and I keep getting Error 70: Permission Denied. The weird thing is that for testing purposes, I left IE visible and the page navigates correctly, but the debug error stops a process that seems to be working. I...
  10. J

    fail to open wanting-new-window via specific site's js code in VBA excel with ie automation

    Hello, I need any help or idea. I did as follows : 1. in browser, connect url, KIPRIS ( real site ). "some url" : 'http://engpat.kipris.or.kr/engpat/searchLogina.do?next=MainSearch' 2. input search keyword and search "search keyword" : 'smart phone' 3. then click any hyperlink of search...
  11. K

    Bypass Save As Prompt when using ExecWB

    So I have this piece of code I've put together to access a website that was created to run reports. The website has some drop downs to select value for a report query and a button to run the report. The code then sets the value to two combo-boxes and clicks a button to query the database. If I...
  12. J

    VBA Follow.Hyperlink potential Lag

    Good morning everyone, I have created the following code, which takes a search term and creates then launches each hyperlink into Internet Explorer - By and large it works, which is great... but it is almost like the code is too fast for Internet Explorer and it only opens every few search...
  13. J

    VBA - FollowHyperlink help needed please!

    Hi everyone, I have come stuck on this, I keep getting a cross site scripting error or and automation error, I must be missing something, but quite honestly I don't know where to look anymore!! - Any help would be great! I have created a series of Boolean strings to search the internet for...
  14. B

    PLEASE HELP! Automating the Download of .zip files...

    Hi Everyone! I was wondering whether anyone could help me please? I need to automate the download of zip files. I can write a code to download other file types from websites but when it downloads a zip, the file corrupts. Is there something that is different about downloading .zip files...
  15. A

    Internet Explorer automation with Excel VBA - beginner question

    Hello everyone, I have been trying to automatically fill in an Internet Explorer form with values from an Excel spreadsheet. I am using the below VBA code to try and select an option from a drop box to begin with. Sub InternetExplorerForm() Dim IntExpl As Object Set IntExpl =...
  16. T

    Intermittent VBA Run-Time Error 91 in Excel 2003 Macro/Windows XP/IE 8.0

    Hi All, I have looked for a day and a 1/2 and googled, read and experimented far and wide but am unable to sovle this problem. I have a VBA routine in Excel that automates logging into a website as follows : <code> Sub Mysub() Dim ie As Object Set ie =...
  17. J

    IE Automation

    I have this script from a site that I use. ' inputtype="submit"value="Post this comment"name="button" I would like a vba that would click on the button on whatever page I am in as the page address changes each time. example. I use appactivate("Internet Explorer") and then I want to hit...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top