PDA

View Full Version : Solved: Microsoft Project 2002



outrider
05-12-2006, 08:03 AM
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. :banghead:
Can anyone help with this irritating problem?




Outrider.

ALe
05-12-2006, 08:21 AM
What do you mean, the application or a file?

outrider
05-14-2006, 12:22 PM
What do you mean, the application or a file?

The application.

mallarym
09-03-2007, 01:39 AM
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:


Excel.Application.onTime downTime, "ShutDown"


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."

mallarym
09-03-2007, 01:48 AM
Also, I modified the shutDown procedure as:
Application.FileSave
Application.FileClose
Application.FileExit