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...
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...
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.
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...
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...
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...
I need any help or idea.
I did as follows :
1. in browser, connect url, KIPRIS ( real site ).
"some url" :
2. input search keyword and search
"search keyword" :
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...
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...
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...
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.
Dim IntExpl As Object
Set IntExpl =...
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 :
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.
appactivate("Internet Explorer") and then I want to hit...