Loop

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Onthefly
    New Member
    • Sep 2006
    • 7

    Loop

    Hey,

    Can someone help me figure out how to make this code loop so that it saves my worksheet every 24 hours:

    Private Sub Workbook_Open()
    'This will run the code 1 minute after the worksheet is opened
    Application.OnT ime Now + TimeValue("24:0 0:00"), "SaveData", , True
    End Sub

    Onthefly
Working...