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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top