Project 2003 - VBA or macro code: Task date triggers the opening of an external .exe file
Posted on 2008-11-03
I have a Ms Project file and to track some Tasks. I would like to have that file open (every day) and if there is a Task that should START today, it will trigger a file called Task.exe that is on C:\
How could this be done (programatically)?
1. Every morning I open Ms Project File "MyBigProject"
2. On Open the .mpp file checks Task Start dates and compares to Today
3. Every specific task has an .exe file associated with THAT particular task, ex. Task 1 has an Task1.exe file lying on C:\TaskFolder
(What these do is to go and collect information from other file systems or databases and put them in a certain order - I scripted them becasue they are recurring and associated with this project).
4. If i have on one day Task 3, Task4 and Task5 the corresponding .exe´s fire up (Task3.exe, Task4.exe, Task5.exe)
How could this be programmed in VBA code? (only complete code will get the points).
Alternatively: I could setup the tasks in Outlook Calendar and every day open up Outlook and have Outlook go into the folder and trigger the exe´s, but maybe this is more difficult since I have to tinker with the Exchange Server, which I do not have access to.
Thanks for your help.