Results 1 to 6 of 6

Thread: Close file after 3 minutes?

Threaded View

  1. Sep 13th, 2004, 08:28 AM #1
    wossname
    wossname is offline

    Thread Starter
    type Woss is new Grumpy; wossname's Avatar
    Join Date
    Aug 2002
    Location
    #!/bin/bash
    Posts
    5,682

    Close file after 3 minutes?

    Why doesn't this code work...

    VB Code:
    1. Public Sub Document_Open()

    2.  
    3. Application.OnTime DateAdd("n", 10, Now), SaveAndClose

    4.  
    5. End Sub

    6.  
    7. Private Function SaveAndClose()

    8.  
    9. Me.Close True

    10.  
    11. End Function

    It is supposed to close a file 10 minutes after it was opened, but instead the file closes instantly.

    Also, why is VBA so lame?
    Last edited by wossname; Sep 13th, 2004 at 08:48 AM.
    I don't live here any more.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width