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