Re: scheduling a server-based app

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <AllenN@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:48B182AE-ACCF-4E06-8F89-1D3F68946021@xxxxxxxxxxxxxxxx
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!


.

Relevant Pages

  • RE: Auto refreshing data via VBA
    ... Private Sub Workbook_Open ... 'runs for the whole time the workbook is open ... Dim LastUpdate As Long ' holds Timer value ... Dim UpdateInterval As Long ' holds seconds between updates ...
    (microsoft.public.excel.programming)
  • vlookup sub procedure help
    ... Updates workbook sheet1 it would look in the closed NetRev ... workbook column B and when found it would update Columns C thru G with the ...
    (microsoft.public.excel.programming)
  • RE: vlookup sub procedure help
    ... Updates workbook sheet1 it would look in the closed NetRev ... workbook column B and when found it would update Columns C thru G with the ...
    (microsoft.public.excel.programming)
  • RE: Excel Tracking Changes
    ... Although you can track changes in a Shared workbook, ... so the fact that you can't use them under sharepoint is no loss. ... I have an excel 2003 workbook with multiple tabs that are updated weekly. ... Can I create a summary tab for the weekly updates that automatically updates ...
    (microsoft.public.excel.worksheet.functions)
  • Re: VBA code halts after opening a file
    ... It seems the selection or activation of the workbook and worksheet might be ... When you say it quits,do you mean the procedure or Excel? ... > The computer a new Compaq running Excel XP SP2 with all available Office ... Critical updates and all but a few of the Recommended updates installed. ...
    (microsoft.public.excel.programming)