ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to auto update Excel Web Page (https://www.excelbanter.com/excel-programming/323455-how-auto-update-excel-web-page.html)

MSW

How to auto update Excel Web Page
 
Hello I'm looking for some guidance on how to go about updating a web page
with Excel data with out manually opening up Excel 2003 and publishing each
time there is new data.

I have an application that runs weekly which extracts data from a report and
saves the data in an XLS file format. I then must open Excel and save as or
publish the entire book to a folder on my webserver. Is there away to write
a macro or other command script that will open the sheet and do the publish
or save as routine for me?

Thanks for your help..Scott


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com