
Read and list mpp files in a dialogue box with VBA
If you want to do this for all .mpp files in a folder, use the Dir command
to list all .mpp files in a folder you nominate, then open each in turn and
read the Subject with the activeproject.BuiltinDocumentProperties method.
Get the status date using: activeproject.StatusDate
Add this data to a VBA UserForm by creating a listbox.
--
Visit www.mvps.org/project/ for the Project MVP's FAQ and third party
add-ons
Rod Gill
Microsoft Project MVP
Visit www.projectlearning.com for customized Project and Office VBA macros
and Project companion software
Quote:
> Hello,
> How can we read and list in a dialogue box (with VBA) all the projects
file
> names .mpp, their "Manager" and their "Status date" ?
> Thanks
> Grard Ducouret