internet and vba

Hi all, I am trying to create some Excel VBA code to automate finding out the distance from coast of 3000 sets of co-ordinates that I have in Excel, my VBA knowledge is very limited. I am planning on using the following website and was wondering if anyone had any idea of how to automate this...

Hi All, I am trying to work on a Macro to login into a website and then download some data. Currently I am having trouble getting it to click on a link in the site. Code: Sub GetHTLMDocuments() Dim IE As New SHDocVw.InternetExplorerMedium Dim HTMLDoc As MSHTML.HTMLDocument Dim...

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;">...

I'm writing a macro to autograb data from a list of websites and one of my websites makes use of a toolbar. To pull up the download button dialog, I need to click a button on the toolbar labeled "Download." The "Download" button I am supposed to click however is not an actual button and has no...

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

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 Guys, I need some help with my script below. I have no issues with part one of the script until when it starts going to the 2nd URL. I'll like the following to be done: 1. I'll like the "Live1" option to be selected. 2. The text to be copied and inserted from excel 3. From the masterIB...

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

Hi People, I've got some VBA code where i log into a website and navigate to a webpage however, i then need to click a tab on that webpage to see the information i want to extract (the URL is different each time as its includes the date and time) therefore I need to use VBA to click on the...

Hi guys i've set a macro up to take me to a webpage. ... now i want to select all and paste all information into "sheet1" cell a1 on my excel document and then copy and paste the data as vales into another tab (don't know the cell ranges yet depends on how the data is important. however on the...

Hi, So as the title says i'm a novice when it comes to VBA used it once before about 2 years ago and didn't really get it :') so the time has come where I require it and still don't get it :) So what i need VBA for: I am currently manually populating a worksheet based on the values from...

So I have this function that returns a value from a web page. The issue with this is that it works perfectly when I run it single step, but when I run it normally it returns another value. Aditionally, the last line of the code, "objIE.Quit", does not run only when I run the program normally...

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'm a long time reader but first time poster. I've spent a long time googling and am hoping someone can help me. My problem: I want to open a specific URL from Excel. The issue is that the URL needs to be opened exactly - I'm using a specific gmail URL string which won't work if it's...

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

Dear all, I'm trying to use VBA to download the odds for Manchester United versus Manchester City. I would like the odds to come from unibet.com which is using flash (i think). Is that possible? If not, is there a way around it? I will really appreciate your help. Kind regrads Rasmus

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

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 all, I understand that this topic was already covered a lot, but I didn't find the answer for exactly my case. The following code works for other web sites, but doesn't work for the one below: On this side https://indexes.nasdaqomx.com/<wbr>Index/History/NQLA5300 you could press the button...