ie automation

  1. B

    Edge automation without installing selenium

    So I heard I can use Edge in IE mode on Windows 10 without installing seleniumbasic. But couldn't find working script. In this link Automating Edge Browser using VBA without downloading Selenium An answer listed possible workarounds. But still there is no working script. I merged that...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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 =...
  17. 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 =...
  18. 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...

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
Back
Top