Trouble with using ProjectSummaryInfo

[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 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

 

[Jan De Messemaeker]

Hi Jeff,

When you use a method for the first time, it is not unusual and generally
wise to read the help on the methods, for instance:
------------------------------------------
ProjectSummaryInfo Method


Sets information about a project.

Syntax

expression.ProjectSummaryInfo(Project, Title, Subject, Author, Company,
Manager, Keywords, Comments, Start, Finish, ScheduleFrom, CurrentDate,
Calendar, StatusDate)

expression Optional. An expression that returns an Application object.

Project Optional String. The file name of the project that should have its
project information edited.

Title Optional String. The title of the project.

Subject Optional String. The subject of the project.

Author Optional String. The author of the project.

Company Optional String. The company associated with the project.

Manager Optional String. The manager of the project.

Keywords Optional String. The keywords associated with the project.

Comments Optional String. The comments associated with the project.

Start Optional Variant. The start date of the project. If ScheduleFrom is
pjProjectFinish, Start is ignored.

Finish Optional Variant. The finish date of the project. If ScheduleFrom
is pjProjectStart, Finish is ignored.

ScheduleFrom Optional Long. Can be one of the following
PjScheduleProjectFrom constants: pjProjectStart or pjProjectFinish.

CurrentDate Optional Variant. The current date for the project.

Calendar Optional String. The name of the base calendar for the project.

StatusDate Optional Variant. The current status date for the project.

Remarks

Using the ProjectSummaryInfo method without specifying any arguments
displays the Project Information dialog box.
--------------------------------------

This explains why you get an error isn't it?
And by the way what is it you are looking for?
Could it be as simple as

Activeproject.Name?

HTH

 

[Buster]

I've read ll the information you were so good to supply. I understand how to
set the actual variables, but not how to retrieve the information.

I am trying to interrogate project plans(aboujt 150) and dump the basics
into a spreadsheet file for distribution after metrics have been applied.

xlRow = ActiveProject.ProjectSummaryInfo("Project")
THis causes an error "runtime error 438"
So what i'm trying to do is retrieve the project name among other things.

Jefff

 

[Jan De Messemaeker]

Hi Jeff,

When you read the help text did you notice the definition of the
projectsummary info method itself:

"SETS INFORMATION ABOUT A PROJECT"

so it CANNOT be used to retrieve any infromation about a project

To retrieve the name of an open project as I wrote (did you really read my
message?) you need

activeproject.name

Most of the projet's properties are readily derived from the project object.
HTH

 

[Buster]

THanks for the info, things finally sunk in for me eventually, as this is my
first programming experience.

One question is how do I extract the name of the calendar being used. I
can't sedem to find a way to extract that info.

Jeff

 

[Jan De Messemaeker]

Hi Buster,

What exactly do you mean?
AFAIK the project calendar is always called Standard
Or are you looking for a task's calendar? Or a Resource Calendar?

 

[Jeff]

I am trying to pull back the project calendar referencedx in the
Project Information dialog box. I need to check and see if the project
is running the Canadian calendar adn not the american. THis is all due
to holidays.

Jeff

 

[Jan De Messemaeker]

Jeff,

Do not look for entries in boxes but for properties to objects:

Activeproject.basecalendars("Standard").name

HTH