Display live(ish) excel data in webpage

Apeman

New Member
Joined
Nov 29, 2018
Messages
7
Hi

I have created some reports in excel and have various pivots and graphs that I can view/refresh. What I would ultimately like to do is have the contents of the excel page displayed via a web browser so this can be seen by people across the business with out them using the excel spreadsheet, I would also like the contents to be displayed on a wall screen. My spreadsheet uses an ODBC link to some data tables that our management system writes to.
I have managed to make it work manually by publishing as a web page and set to republish every time workbook is saved, I have used an auto refresh plug-in for chrome, i just need it automating! I am thinking that I need an auto refresh function adding, to refresh the data tables and a timed auto-save function, which will in turn refresh and save the workbook every minute (or two).

I am a bit of a VBA noob, and most of the stuff I know I have picked up from forums like this, so I am sure this is pretty simple, but I simply just don't know how to do it!

Any help on this would be most appreciated. Thanks in advance
 

Forum statistics

Threads
1,085,542
Messages
5,384,327
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top