Trouble with using ProjectSummaryInfo

J

Jeff

I am trying to retrieve the various elements of info associated with
using ProjectSummaryInfo.

xlRow = ActiveProject.ProjectSummaryInfo("Project")

THis causes an error "runtime error 438"

I can find examples of wrting to the ProjectSummaryInfo for selected
variables, but I am unsure where I have gone wrong here.

I have successfully use this same method to retrieve the
Builtindocumentproperties.
xlRow = ActiveProject.BuiltinDocumentProperties.Item("Title").Value

any ideas on how to get this to work, I've searched the newsgroups but
there is not to much on the subject
 
J

John

I am trying to retrieve the various elements of info associated with
using ProjectSummaryInfo.

xlRow = ActiveProject.ProjectSummaryInfo("Project")

THis causes an error "runtime error 438"

I can find examples of wrting to the ProjectSummaryInfo for selected
variables, but I am unsure where I have gone wrong here.

I have successfully use this same method to retrieve the
Builtindocumentproperties.
xlRow = ActiveProject.BuiltinDocumentProperties.Item("Title").Value

any ideas on how to get this to work, I've searched the newsgroups but
there is not to much on the subject
Click to expand...

Jeff,
You probably get a runtime error because the ProjectSummaryInfo Method
applies to an Application object, not a Project object. This is clearly
spelled out in the VBA help file. Also this method is used to set the
information, not retrieve it. And how you intend to relate it to an
Excel row object, I have no idea.

John
 
Top