HobbitHouse
asked on
MS Project data via Visual Basic
I'm expert at using Visual Basic to get MS Project data out of an MS Access file once the project is saved in MDB format, but now I'm trying to use VB to go directly to the project file.
I'm getting lots of stuff just fine (tasks, resources, etc.), but one thing I can't get is the project info. This is the stuff that in project you get by going to file >> properties >> summary
There is a VB function for the project object:
Function ProjectSummaryInfo([Projec
[Author], [Company], [Manager], [Keywords], [Comments], _
[Start], [Finish], [ScheduleFrom], [CurrentDate], [Calendar], _
[StatusDate], [Priority]) As Boolean
that works great to SET any of the listed values, but what I can't figure out is how do you GET the values. I know where they are in the MDB file, but can't find them in the MPP file itself.
any suggestions?
I'm getting lots of stuff just fine (tasks, resources, etc.), but one thing I can't get is the project info. This is the stuff that in project you get by going to file >> properties >> summary
There is a VB function for the project object:
Function ProjectSummaryInfo([Projec
[Author], [Company], [Manager], [Keywords], [Comments], _
[Start], [Finish], [ScheduleFrom], [CurrentDate], [Calendar], _
[StatusDate], [Priority]) As Boolean
that works great to SET any of the listed values, but what I can't figure out is how do you GET the values. I know where they are in the MDB file, but can't find them in the MPP file itself.
any suggestions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OOPS, wrong glasses... sorry :(
ASKER
Brian,
That's cool
I found another way to do it (and it doesn't require late binding and works well with my other code, which yours doesn't because of the late binding), BUT your response was prompt and teaches me something new, so I'll happily give you the points & my thanks.
a related question that you might be able to help with: The reason I couldn't find it right away is that my object browser help doesn't work for MS Project & I'm wondering if yours does. I assume that generally it does and that mine is on the fritz & needs to be reinstalled. So that's my question, really --- does your object browswer work for MS Project? That is, if you go to Object Browser >> MS Project >> application >> active cell (just to pick one of the first things that comes up) and you then click on the help icon, do you get help? I don't --- all I get is a msg box saying "unable to display help"
my solution, by the way, just uses, for example
Dim proj As MSProject.Application
Set proj = New MSProject.Application
proj.FileOpen Name:="e:\adev\vb\ms project play\P_DA.mpp"
msgbox proj.ActiveProject.Author
That's cool
I found another way to do it (and it doesn't require late binding and works well with my other code, which yours doesn't because of the late binding), BUT your response was prompt and teaches me something new, so I'll happily give you the points & my thanks.
a related question that you might be able to help with: The reason I couldn't find it right away is that my object browser help doesn't work for MS Project & I'm wondering if yours does. I assume that generally it does and that mine is on the fritz & needs to be reinstalled. So that's my question, really --- does your object browswer work for MS Project? That is, if you go to Object Browser >> MS Project >> application >> active cell (just to pick one of the first things that comes up) and you then click on the help icon, do you get help? I don't --- all I get is a msg box saying "unable to display help"
my solution, by the way, just uses, for example
Dim proj As MSProject.Application
Set proj = New MSProject.Application
proj.FileOpen Name:="e:\adev\vb\ms project play\P_DA.mpp"
msgbox proj.ActiveProject.Author
ASKER
Brian,
That's cool
I found another way to do it (and it doesn't require late binding and works well with my other code, which yours doesn't because of the late binding), BUT your response was prompt and teaches me something new, so I'll happily give you the points & my thanks.
a related question that you might be able to help with: The reason I couldn't find it right away is that my object browser help doesn't work for MS Project & I'm wondering if yours does. I assume that generally it does and that mine is on the fritz & needs to be reinstalled. So that's my question, really --- does your object browswer work for MS Project? That is, if you go to Object Browser >> MS Project >> application >> active cell (just to pick one of the first things that comes up) and you then click on the help icon, do you get help? I don't --- all I get is a msg box saying "unable to display help"
my solution, by the way, just uses, for example
Dim proj As MSProject.Application
Set proj = New MSProject.Application
proj.FileOpen Name:="e:\adev\vb\ms project play\P_DA.mpp"
msgbox proj.ActiveProject.Author
That's cool
I found another way to do it (and it doesn't require late binding and works well with my other code, which yours doesn't because of the late binding), BUT your response was prompt and teaches me something new, so I'll happily give you the points & my thanks.
a related question that you might be able to help with: The reason I couldn't find it right away is that my object browser help doesn't work for MS Project & I'm wondering if yours does. I assume that generally it does and that mine is on the fritz & needs to be reinstalled. So that's my question, really --- does your object browswer work for MS Project? That is, if you go to Object Browser >> MS Project >> application >> active cell (just to pick one of the first things that comes up) and you then click on the help icon, do you get help? I don't --- all I get is a msg box saying "unable to display help"
my solution, by the way, just uses, for example
Dim proj As MSProject.Application
Set proj = New MSProject.Application
proj.FileOpen Name:="e:\adev\vb\ms project play\P_DA.mpp"
msgbox proj.ActiveProject.Author
Wow, thanks for the points and glad you got it solved though in a different way but that seems inherent to the work we do ;)
the browser is working here, all of the entries and even the F1-help on them
but it's not working as you get in the rest of office like context sensitive it seems, you got to look it up, i got only project 2000 installed here especially for EE questions so i don't look into it that much
the help is popping but not with help about the vba properties and methods on the object
aha, i haven't installed context help for VBA, so it asks for the CD, and after that it worked. seems a bit strange i could look up some vba help in the normal helpfile anyway
to make a long story short, it worked after installing ;)
the browser is working here, all of the entries and even the F1-help on them
but it's not working as you get in the rest of office like context sensitive it seems, you got to look it up, i got only project 2000 installed here especially for EE questions so i don't look into it that much
the help is popping but not with help about the vba properties and methods on the object
aha, i haven't installed context help for VBA, so it asks for the CD, and after that it worked. seems a bit strange i could look up some vba help in the normal helpfile anyway
to make a long story short, it worked after installing ;)
Don't really follow this one bruintje.
Regards