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