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