import data from web

Hi Guys, I have built a pretty cool fully automated golf pool spreadsheet and discovered that I can bring in the Live Scoring from the web which would COMPLETELY automate the process (and look pretty fancy in the process). The problem is I've never used Power Query, but I have the M-Code that...

I have successfully imported a table no problems here...now the tricky part. Each row contains a hyperlink to a project page, which in turn has a hyperlink to a project - organizations page. Coincidently, on the project - organizations page there is a next button so it is also easy to jump from...

Even though i can write little bit VB code, I am relative beginner, hence i would like if someone could help me with this. I have set up a perfect loop, that changes cell values from named table here is code: Sub LoopThroughForEachCellInARange() Dim OutputAddress As String Dim rng As...

Hi all, This is my first post - sorry if this has been answered before (I'm guessing it has). I have an excel workbook with multiple sheets. "Sheet A" pulls data from an MLB website via web query. This updates daily and I have no issues with the data being imported. On "Sheet B", I pull...

Hello, I want to pull some financial data from a website. Google Sheets has a fantastic function for grabbing data from tables. In my example, I want to pull the balance sheet for a specific company. Here is a link to the Google Sheets' example Is there an Excel equivalent? I tried getting...

Greeting's, I want to wish everyone a very happy new year. Hope everyone has a good one! I want to import NAV (Net asset value) of Mutual funds to a cell. I want to do this to know current network by multiplying NAV with number of units. I have three webpages to pull the data from: (Following...

Hello all, Forgive my ignorance here, as I am an extreme amateur in the Excel game. I have been searching Google in an attempt to find an example of a macro to accomplish what I want, but since I have little knowledge, it is difficult to know what exactly to search for. This being said, if...

Hi, I am trying to import a data table of Premier League odds from a website however when I use the import function It doesnt include the table. Is the some code I can use to import just the table with the Premier League odds on it? All I get is the menus and not the fixtures and odds. Any help...

I'm using Excel 2003 and 2010 and trying to import the main table from the following link:Nasdaq New Highs & Lows - Markets Data Center - WSJ.com The targeted table is labeled atop "New 52-Week Highs:" When I use the "New Web Query" menu function and insert the link, the first unusual...

Hi, I am trying to import these tennis stats into a worksheet but there are no yellow arrows to select the data I want to import. Does anyone know if it is possible to import data from the following webpage...

Hi. I want to import betting odds from i.e. bet365 - Sports Betting, La Liga and Bundesliga Football Odds, plus Cricket World Cup Prices, Casino, Poker, Games, Bingo into Excel, but when I use the "from Internet" option (which I normally do) I'm not getting an option to choose the odds...

Hello, My Excel table column contains web url's. Need to VBA code to get spesific html tags inner text and write them to in my row range. <tbody> Links data1 data2 data3 data4 data5 www.abc.com/?d=123 abc green table 34 %65 www.abc.com/?d=124 def blue chair 63 %66 www.abc.com/?d=125 tht...

Hi, I was wondering if anyone could help with this query. I have a worksheet that imports data from a website using a simple web query import. The thing is there are 3 different sections of the web address that I would like vba to replace each time based on text that is in Cells A2, B2 and D2...

Hello all! I am attempting to write a code that scrapes the chart found at Fantasy Baseball Projections and places it in a sheet titled "P". I have been having some issues getting the VBA to recognize the chart (i believe its id is "projection-data"). Any and all help would be appreciated...

Hi all, I have been tasked with streamlining a process to collect data from a specific online website and import it into an Excel 2010 spreadsheet. Website is 'Web of Science', Web of Science [v.5.13.3] - All Databases Home which is a site that details academic publications and journals...

Good Morning All! We have an internal LMS which houses courses and learners. For each of the courses in the system a maximum of 250 learners can be displayed on a single page. Some of the courses have up to 5000 learners which results in multiple pages to sift through. What I would like to be...

Hi Lovely People of Mr Excel, HSBC won't let me download more than 90 rows of transactions in excel format. This is an issue when I want to get every transaction for 2013 from my current account. So what I have done it view my previous statements which load up in the browser in whatever format...

Hi, I'm having this problem: i have a list or URLs on a sheet, and i want a macro that import a table (always the table 2) from the URL contained in the selected cell. When I record the macro, it doesn't store 'the selected cell' as the place where it gets the information about where to obtain...

Hi all, I have a problem creating a macro that opens a web page, goes to a specific section of the page (by clicking on a link), introduces a captcha code (from an image) and then imports into excel the tables shown above the form. Then goes to the following page of tables and imports (through...

Hello, I have recently tried to use the Web Query Wizard in Excel and got this error: "This web query returned no data. To change the query, click OK, click arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and...