internet explorer

Hello, I am working on a project where I need to pull data from a website. The website requires that I sign in using a username, which I have already done. I then get taken to a landing "Home" page, but I need to navigate from that page to my desired webpage. From there I need to scrap the...

Hey Everyone, Thank you for taking the time to read this, I am currently a novice VBA programmer beginning to learn the basics of visual basics. I had been trying to design a program to view/download current tax forms for client viewing. The program as designed is supposed to visit a page and...

Hi There, I need to submit one form & then submit a second form that only appears after the first is submitted. How do I refocus the .document reference to bring in the new objects created after submitting form 1? Code is below, along w/ a list of all reference libraries I'm using...

Hi There, Been struggling w/ this code for a week or so now. Essentially, what I want to do is click on/fire the JavaScript link that shows up in form(2) (coach's Last Name, First Name) after pressing Submit on the button on form(0). However, VBA doesn't seem to be recognizing form(2) at all...

Basic set up is I have a userform with a textbox & button. Put text in the box & click the button, It calls sub FNN_lookup(FNN). This sub have the "ieApp.Visible = False" line but internet explorer still ends up being visible. Any Ideas as to why? the sub has been tested without the userform and...

I'm writing a VBA script that will open internet explorer, navigate to a certain webpage, apply search filters, submit the search form, and click the "Export to Excel" button for the table of data that gets presented. The code is working perfect up to the point of clicking the button to export...

Hi all, Long time browser of this site and others. Been slowly picking up some vba skills by reading others questions online. After over a year of doing this, I've finally ran into a situation where I can't get something to work after many hours looking online and trying many things. Hoping I'm...

Hi Guys. I'm using the following code to work out if a link to a url is broken or not: strURL = Activecell.value 'this is the url to test Set objhttp = CreateObject("MSXML2.XMLHTTP") objhttp.Open "HEAD", strUrl, False objhttp.send...

Hi All. I'm using the following code to navigate Internet Explorer around: With IE .Visible = False .Navigate "http://www.domain.com/" 'this is could be any domain Do Until .readyState = 4: DoEvents: Loop End With Sometimes...

How to login to enable web query in vba excel - Stack Overflow This person had a similar issue, but it wasn't really resolved. I'm hoping that the people at MrExcel would be able to help me out with this. I'm using a VBA macro to log into a website using InternetExplorer.Application. My issue...

Hi Guys. I have an excel app that navigates Internet Explorer to webpages via VBA. I'd just like to know if there's a way to return the url of the current web page from Internet Explorer. The reason for this is that I want to be able to check that I haven't been redirected to another domain...

Hi All. For an excel app I'm building I need to (effectively) open a url in internet explorer, select all, and paste onto a sheet... or VBA equivalent. However, I'm not after the source code... I'm after the text that the website visitor would see in their browser. If images etc end up coming...

I'm tired of trying to go through brick walls. I'm willing to try going around. I've been using Excel VBA to automate Internet explorer for several years now. All of my knowledge has come from online examples and the school of hard knocks. On top of that it's 3-6 months between coding...

Hi Guys. I have two computers at home. One is my every day workhorse. One is for 'automation' tasks. I have a macro I've written which opens internet explorer to a url then brings the innerhtml content into a sheet separated by < so that I may process each tag. On my workhorse PC everything...

Hi there ! I would like to download a file from a website using VBA. The tricky part is that the file is generated after filling a form in the webpage and clicking on the submit button, so I don't know its name and address before download (meaning I can't use the URLDownloadToFile API)...

I have several worksheets at work that are used by various users. The site ie is navigating to is an internal website. For most there is no need for the code to log them in as there currently logged in on another instance of IE. But a few users have to log in each time excel opens a new...

Hi, I am looking to click a button on this webpage Geology of Britain viewer | British Geological Survey (BGS), specifically the one labelled Go To Location (RHS). I cant figure out what its reference is when I look at the source code. My VBA is below, which doesn't work...Sub Geol() Dim sht...

Hi All, I'm hoping you could help me with an issue I've been having while trying to search for values from a label array on a webpage. What I'm trying to do is find a value from a label on a userform on a webpage and then have it display the results back on the userform. The loop seems to work...

Does anyone have a good script (or can think of one) to extract all the links from any given URL into a column in excel? I have a version at the moment, but it downloads the page source to a text file then imports it to excel and extracts the links... seems a long way round. I've had a good...

Hello, I'm creating a vba script to open up an Internet Explorer form and populate it. Everything works (text boxes populate, regular button clicks works). However, when creating a .click method for a radio button (normally if a user manually clicks it, it gets redirected to a new page with the...