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.
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.
What do you mean, the application or a file?
The application.Originally Posted by ALe
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."
Also, I modified the shutDown procedure as:
[VBA]Application.FileSave
Application.FileClose
Application.FileExit[/VBA]