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
Bookmarks