web data excel

Hi all, I have a code for getting data from a specific website. But when I run it I get an error (Compile Error: User-Defined Type Not Defined) at "Dim html As New HTMLDocument" Can somebody please help me with this problem? Sub Get_Web_Data() Dim request As Object Dim response As String Dim...

Hi All, I'm working as analyst and I have been using web queries in Excel as a way to automatically get stats into my spreadsheets which are formatted for further analysis. Previously i was getting data from a different website which is no more operational. Now I have to import data through...

Hi all, My problem is two-fold. I have a worksheet already created that has a list of Football Leagues (in the rows), the columns hold the data. I have some code that fetches data from a website and populates this sheet (each row contains data corresponding to a league). It currently works, but...

Another user (Domenic) has kindly helped create code to extract some data from a website (see OP https://www.mrexcel.com/forum/excel-questions/1095752-extracting-data-website-html-using-vba.html) I originally wanted to extract data from betexplorer.com. I wanted to extract two different pieces...

Hello, I have been trying putting together a code to get scroll table data from web to excel from an internal url which does not open in IE. The code I have, however, only takes table (column) headings, not the values from table itself. The table on web updates every once a while on would be...

I am trying to scrap video names and hyperlinks from one of the channels i have subscribed, the goal is to get all videos names on that page and create a hyperlink, below is the code that i have created and works so far, the problem i am facing is that it only fetches the data that is displayed...

Hi Friends, I tried finding VBA code on MRexcel forum. But did not find suitable one. A VBA Macro to extract whole webpage data including hyperlinks for example url: https://www.dice.com/company/07960AP <colgroup><col width="64"></colgroup><tbody> </tbody> Not only from this website, I...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

First of all I have read ALOT of different answers online in relation to this topic but I have to admit I am really struggling to adapt them to what I need so please any help is very much appreciated! I need to extract the data listed on the following webpage (Pages 1-7) i.e. Fund Name, Price...

Dim org As Workbook: Set org = ActiveWorkbook Dim temp As Workbook: Dim mPath As String: mPath = org.Worksheets("TEMP").Range("s7").Value On Error Resume Next Workbooks.Open filename:=mPath ActiveWorkbook.Activate Range("k6").Copy temp.Activate On Error Resume...

I'm new to this forum. I have some experience with VBA but none with HTML or Javascript. I am trying to get excel to reference (and regularly refresh once a day) 5 different data tables from a single url of a website that changes the data depending on 5 different regions of a U.S. map. I tried a...

I am trying take values from excel to web app here is the code. it is not working. I am attaching the source code of the html How can i automate excel to web application Option ExplicitSub SubmitToWeb()Dim rw As Long, ws As WorksheetDim IE As ObjectApplication.ScreenUpdating = False Set...

Dear sir/madam, I am new to Excel and have no programming experience, so please bear with me... I am desperately looking for a solution for the following problem: Right now I am manually using a website (http://gpx.cgtk.co.uk/) to get a list of latitude and longitude points of a certain...

I need to copy some Olympics data from the Olympics website about Medal tally. The website is Medal Count - Olympic Results & Medalists | IOC , and i need to look for Medalists (the right hand side) By country and then by Olympics. This opens a new page with the following Columns (which i need...

I am needing to collect data off of a website. It is all in table format already and I have experimented with Data>Get External Data>From Web. This is ideal and works perfectly. However I need to get more information from it. The URL are...

I need excel to open this webpage: https://www.midwestiso.org/MARKETSOPERATIONS/REALTIMEMARKETDATA/Pages/LMPContourMap.aspx then select the link to the csv file and download it, then open it in excel. I would like to automate this process to happen every 5 minutes, so that I can create a database.

Hi all, I am new to the forum so please stay with me on this one. I may just need to be pointed to another thread that has addressed this issue already. I would like to develop a Macro that does the following: Collects person's name and address in a form field in Excel, then uses the...

Basic question: Can you import elements of a table into excel using a web query or some other type of web connection without importing entire table into excel? lets say I want to get DAY PRICE and 1 and 2 DAY PRICE EXP RATE VOL 1.0 2.0 U2 3.479 8/27/09 0.015 0.84 .49 .52 V2 3.76 9/28/09...