run vba in scheduled task

[Scott Sanders USA]

Hi,
Is it possible to run Project Pro 2003 vba code outside of project? I have
code that opens all projects and saves them as mpp files on a file server.
It works great from within project, but i would like to automate the process.
Any guidance is appriciated.
--Scott

 

[John]

Hi,
Is it possible to run Project Pro 2003 vba code outside of project? I have
code that opens all projects and saves them as mpp files on a file server.
It works great from within project, but i would like to automate the process.
Any guidance is appriciated.
--Scott

Scott,
No. That's why it is called VBA (Visual Basic for Applications). What
you want is the stand alone version of Visual Basic (e.g. VB6 or
VB.net). Those applications create code that runs independently of the
target application.

John
Project MVP

 

[Rod Gill]

Alternatively just have the code in an empty .mpp file and use the
project_open event to start the code and quit project when complete. That
way opening the macro project runs it like a stand alone program!. Hold
shift key down when opening to prevent the project_open code from running.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com