ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   scheduling a server-based app (https://www.excelbanter.com/excel-programming/375697-scheduling-server-based-app.html)

Allen_N

scheduling a server-based app
 
This question follows on from my last one (subj = "deploying Custom.xls"),
and may not be appropriate for this forum: how can I get a server-based Excel
workbook to automatically update itself on a weekly basis? (Currently, I
manually load the workbook and run a macro.)

Thanks!


RB Smissaert

scheduling a server-based app
 
Use the Windows task scheduler to open the workbook.
In the Workbook_Open event put the code that updates and saves
the workbook and at the end quits Excel.

RBS

"Allen_N" wrote in message
...
This question follows on from my last one (subj = "deploying Custom.xls"),
and may not be appropriate for this forum: how can I get a server-based
Excel
workbook to automatically update itself on a weekly basis? (Currently, I
manually load the workbook and run a macro.)

Thanks!




All times are GMT +1. The time now is 06:42 AM.

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