Consulting

Results 1 to 5 of 5

Thread: Solved: Microsoft Project 2002

  1. #1
    VBAX Regular
    Joined
    Dec 2004
    Posts
    26
    Location

    Solved: Microsoft Project 2002

    Trying to create a shutdown timer for Project, in excel it is not a problem but the vba for Project seems quite different, so far, every thing I have tried fails.
    Can anyone help with this irritating problem?




    Outrider.

  2. #2
    VBAX Mentor ALe's Avatar
    Joined
    Aug 2005
    Location
    Milan
    Posts
    383
    Location
    What do you mean, the application or a file?

  3. #3
    VBAX Regular
    Joined
    Dec 2004
    Posts
    26
    Location
    Quote Originally Posted by ALe
    What do you mean, the application or a file?
    The application.

  4. #4
    VBAX Regular
    Joined
    Sep 2007
    Posts
    16
    Location
    I am working on the same issue. I am almost there, but I am doing something boneheaded where it can't find the shutdown macro.

    I am using the code from other thread for excel Time. In Project, I went to the VBE, and added the Excel Library. Then, I was able to call the excel onTime function:

    [VBA]
    Excel.Application.onTime downTime, "ShutDown"
    [/VBA]

    The Shutdown procedure works fine if I run it from VBE or from Tools>Macro> Run Macro. However, when the timer hits the shutdown time, it says it "cannot find macro ShutDown."

  5. #5
    VBAX Regular
    Joined
    Sep 2007
    Posts
    16
    Location
    Also, I modified the shutDown procedure as:
    [VBA]Application.FileSave
    Application.FileClose
    Application.FileExit[/VBA]

Posting Permissions

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