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

Some videos you may like

This Week's Hot Topics

Top