internet automation

I am currently trying to make a VBA code which would multiple files from a given URL. These VBA code should do the following things: 1. Open internet explorer ***in the background*** and download multiple files from a link. Basically, to download multiple files I should change file code in the...

Hi Team, just checking for possible solution on how to auto select dropdown on a web using vba. This is the elements I have. <fieldset> <legend>Form Question</legend> <div class="select_question chosen-parent" id="question_12213765_response" style="overflow: visible;">...

Hello, I'm hoping someone can help me as I've not done this before. I've written macros but never any that interact with Internet Explorer. I'm trying to automate a task that will allow the user to run the macro to copy specific text from an open browser window and paste the values into...

Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...

I have an Excel document. It creates an Internet Explorer instance and navigates to a URL. *I am testing this with duckduckgo* I want to be able to respond, within vba, to a button being clicked on the website. `html.querySelector("#search_button_homepage")` finds the input element, how can I...

Hi All i am trying to create a script to upload a wallpaper after signing. So far got through this after several attempts, your help is greatly appreciated. Source: Upload Upload current code Dim HTMLDoc As HTMLDocumentDim MyBrowser As InternetExplorer Sub VCW() Dim MyHTML_Element...

Hi everyone, I am running into issues retrieving data back into excel after I automate the click on the web page. The html code that I believe has the results is[HTML]div class="zipcode-result-address"> 123...

I am attempting to set up some IE automation; however, I am running into an error where it states that the object is not supported. Here is where the code is throwing an error .document.GetElementsByName("byaddress").Click I might be calling the wrong element. The a title="byaddress" Here is...

Hello, I am having trouble with the below code. For some reason it will give a run-time error sometimes, but it is completely random. Unfortunately I can't provide the URL since it is internal but I'm thinking this error is due to a timing issue. As you can see below was my attempt at fixing...

Hello, please help I'm trying to create macro which will pull data from site I was using this code for others projects. However, It's not working with http://www.phila.gov/water/swmap/ I think the problem is in Set Element = .document.getElementsByName("searchText") Maybe I didn't choose...

Hi, I've seen this same question posted on this forum as an avid viewer but I can't seem to relate any of the answers to my HTML so I'm looking for some help. Below is my HTML. <img class="hand" type="image" name="addNewJobImage" src="images/btn_add.gif" alt="Add Job" *******="addJob('new')...

Hi all - first time poster, long time follower here! I have a website https://www.top10erp.org/erp-software-comparison-distribution-industry-164 that contains a table with a load of links. Each link takes you to a different (non-indexable) page. I'd like to copy the body of text from each page...

So I apologize if there is a comprehensive guide to this somewhere.. I have scoured the internet and these forums searching for everything I can, but I cannot find what I'm looking for. I am not new to macros at all, but I am unfamiliar with using them to automate IE. Essentially what I need...

Hi guys So far, I have managed to open IE and click the dropdown menu. But I am having a hard time selecting any of the options in the drop down list. Can anyone help? Please find the code below. Rgds Sub OpenWebSelectClickSaveHtmlFile()Dim URL As String URL =...

Hello, I have a vba code attached to a button to open a webpage, fill an input field with data from the workbook, and click the submit button. Upon opening the workbook, click the button opens the webpage, but that's it. If you go back and click the button again, it loads the page again, and...

Hi, I'm looking for codes to get access to a webpage which is already open. I don't want vba to open the url for me as user will manually login into that. Once webpage is ready, vba will input data from excel to webpage. I can manage the codes to feed data but not sure of how to get in to the...

Hi, I am trying to use VBA to log into a website and then complete several actions. So far I managed to log into the page, but I am unable to then click a button/link in a sub-menu. I would be really grateful for any advice on how to execute the link in this sub-menu. Thanks a lot! My VBA...

Hi, I am trying to open a website and log into it using VBA. The probelm I run into is that the username and password are only filled in "superficially". Hence when the VBA code clicks the login button it asks me to enter a username and password. When I click into the username and password...

Greetings, I've been reading this forum for a couple years now, but this is my first time posting a question. As they say on the radio call-in shows, "First-time, Long-time." While I've grown leaps and bounds in my general excel macro writing, I am just beginning to delve into automating...

Hello - first post here :) I'm a VBA newbie and haven't really started with the easiest project! I'm trying to pull some data out of a website using a VBA macro and would like it to use an existing IE window (as it requires user intevention to find the correct page in the first place - this...