+ Reply to Thread
Results 1 to 1 of 1

Download Online Html Table Into Excel Table

  1. #1
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Download Online Html Table Into Excel Table

    hey you guys,

    per the title, I am looking for a way to do this. I believe Excel has the option to automate the downloading of an HTML table using the querying resources, doesn't it? It's been years since I've used that part of Excel, and I don't remember it being power query. It was something else. The reason I want to do this is to give the business owner a very simple tool in the form of an MS Access database to see his website traffic. From what i understand, google analytics does not do what this PHP script of mine is doing. Below is the page I'm referring to. This is nothing more than using PHP and HTML/CSS to print data to the screen. Not complex at all. Can anyone point me to some internet resources that are good for this type of automation? If I get this into Excel in an automated fashion, I can always use VBA to throw it to access. That part is simple. Can any of you experts help in this regard? Thanks!

    The report address is attached to this post. This forum's software is a little too good to allow me to include it here. If any moderators are looking at this, do you guys use CloudFare here?

    thanks!

    Adam
    Attached Files Attached Files
    Last edited by vba_php; 03-02-2020 at 02:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Online on Sharepoint Pivot Table Issue
    By gregwong in forum Excel General
    Replies: 0
    Last Post: 11-15-2018, 03:03 PM
  2. How to See Table Names in Excel Online?
    By gregwong in forum Excel General
    Replies: 0
    Last Post: 11-06-2018, 01:03 PM
  3. [SOLVED] Partial Data Table Download from Web to Excel
    By JigneshBavishi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2017, 11:19 AM
  4. [SOLVED] Partial Data Table Download from Web to Excel
    By JigneshBavishi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-25-2017, 11:00 AM
  5. Extract html table data from specifi table only
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2016, 02:34 PM
  6. download and set table in excel from web that uses Java script
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-08-2016, 09:37 AM
  7. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1