web data extraction

Hello guys, i am working on project where i need vba code to click on "Add Filter", code here looks like - <div class="select-filter-field no-filters" ng-class="{'no-filters' : currentOptions.length === 0}" ng-click="addFilter()"> <i class="fa fa-fw fa-filter"></i> Add filter...

Hi, I need to select option "Assigned to anyone" from below code. it looks like drop down list. HTML for it is as below <select class="form-control ng-pristine ng-untouched ng-valid ng-not-empty" ng-model="viewOptions.assignedToMe" ng-options="opt.value as opt.label for opt in...

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

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

Hi all, I have literally no idea how to do this, but i have seen that it is possible. I am looking for a VBA script that extracts some data (in the From the following site i wish to extract two different pieces of data: https://www.betexplorer.com/soccer/south-korea/k-league-1/stats/ I...

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

Hello, remembers of the forum I'm having troubles with webpage scrapping by using VBA I know I can select element of page by using - getElementByID - getElementsByClassName - getElementsByTagName However, I have no idea how to get data by Attribute For example...

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

I have the following code: Sub RetrieveData() 'dimension (set aside memory for) our variables Dim objIE As InternetExplorer Dim ele As Object Dim y As Integer 'start a new browser instance Set objIE = New InternetExplorer 'make browser visible objIE.Visible...

So the following code hopes to return the entirety of the play-by-play table at a link like this: Providence vs. Villanova - Play-By-Play - January 24, 2016 - ESPN. Sub test() Set IE = CreateObject("InternetExplorer.Application") my_url =...

I'm strugling with VBA code. I'm quite new at VBA programming. The code below returns an error at line with mid function Scraping from web page works OK (red bold text). I would like to get only part of the text. Sample of data from web page looks like this: firstXXXXsecond Desired result of...

Hello All, I am having trouble being able to capture what I need from an HTML website to extract data for my VBA code. My code automatically uses a webpage to search the distance between two airports. That part works fine, extracting the actual value of the distance is giving me problems. The...

I started a thread entitled "Dynamic web query". That is working well except for one issue. Some parts for a certain vendor do not display correctly. I ran macros in an attempt to determine why. Although the eventual data returned is correct, the data pasted into my spreadsheet is not...

I'm trying to import a table from a webpage, but am having problems with formatting. For example, using this webpage and slice of code as an example: www.kenpom.com With ActiveSheet.QueryTables.Add(Connection:="URL;http://kenpom.com", _ Destination:=Range("$A$1")) .name =...

Hi All, Need your help in creating a macro to extract some data from web and fill in an excel. I have tried to work on an existing macro and made few changes to it to as per my requirement. Am able to get the raw data in a worksheet but not able to get it in to an other sheet in required...

Hi excel gurus, I almost there , but I not able to progress :banghead: , i have my code below and I'd to ask for help. Few free to comment about my code below , I not sure if this is the best way to do it.Thank you in advanced. I try to get the data from the webpage as you can see in the code...

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

Hi, I am trying to use excel to extract data and have reached a roadblock when it comes to extracting website contents. The three things I would like to be able to do are: 1) Bring up an open internet browser (preferably Firefox but IE will do) 2) Select and copy entire webpage contents 3)...