web data excel

  1. T

    VBA code to get specific web data: Error

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

    Web Query not recognizing tables on page

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

    Changing a loop and finding a HREF links using VBA and appending fetched links from sheet

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

    Using extracted website data to fill sheet in VBA

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

    VBA to scrape Web scroll-table into excel

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

    VBA Web Scrapping - XML Method

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

    VBA to fetch Whole webpage data from list of webpages excel

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

    Linking Web Data with Excel

    <!--[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>...
  9. S

    How to pull listed data from several web pages into excel

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

    copy workbook data into web adi excel workbook

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

    Auto-Update Data from Same Table of a URL

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

    vba to web automation

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

    get data from web into excel cells

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

    Copy Data from Different pages of a website into Excel

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

    Copying Data From Website

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

    open a webpage and download a csv file from excel

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

    Macro to Search multiple websites and return data

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

    Web Query Excel VBA/ elements of a table

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top