Change File properties in MS Project 2003 using VBA

[technar]

Hi,Can anyone help with writing a macro in VBA to change File properties in MS Project?I.e. File --> Properties --> Title, Author, Keywords etc.We need to change Keywords on a number of projects every month and I wanted to automate it but didn't have much luck.Used BuildInDocumentProperties in Excel and it worked.

ThisWorkbook.BuiltinDocumentProperties("title") = "YourTitle"

But can't make it work in MS Project.Many thanks for your help!(PS. I am an ABSOLUTE beginner in VBA)

 

[SkipVought]

hi,

I would venture to say that not very many people use MS Project, let alone program in MS Project VBA, so YOU will have to do some legwork and heavy lifting.

Have you checked in VBA help to look at the MS Project Object Model? Check out the ThisProject Object. Use the Watch Window to "discover" what you are looking for (using the ThisProject Object) faq707-4594

Post back with your questions.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

Have a look here:

http://msdn.microsoft.com/en-us/library/aa206979(v=office.11).aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[technar]

This works:
ActiveProject.BuiltinDocumentProperties("Keywords") = "Your text here