MS Project Addins

[dotnet-force]

Hi all,

I'm trying to write a MS Project 2002 addin in C#.
I'm facing a very frustating problem : I'm not able to get documentation
on the Microsoft Project 2002 Objects model.

On the following page we can get all objects in MS Project
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/pdr/pdr_extending_olap_3347.asp

But we don't have a peace of explanation of the fields, the methods we
can apply on and the parameters description and types.

Does someone could give me a pointer to such a documentation ?

My current problem is that I want to get the non working day for a
resource between two dates. I have the resource calendar
(MSProject.Calendar object) but I don't know what to do.
I think I have to use the Period(object start, object end) method but I
don't know the type of start and end argument.

Thanks.
Pascal Lenormand
ILOG

 

[Wei-Dong Xu [MSFT]]

Hi Pascal,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this issue, you need the project 2002 sdk for your add-in development.

You can download the project 2002 SDK from Microsoft.com from the link below:
Microsoft Project 2002: Software Development Kit (SDK)
http://www.microsoft.com/downloads/...1b-5307-4ca4-a7e2-345affc14758&displaylang=en

Furthermore, so far as I know, the syntax for Period is listed below:
'--------------------------------------------------------------------------
expression.Period(Start, Finish)
expression Optional. An expression that returns a Calendar object.

Start Required Variant. The start date of the desired period.

Finish Optional Variant. The finish date of the desired period. The default value is the same date as Start.

Sample:
'Code begin
Sub SetWinterHoliday()
ActiveProject.Calendar.Period("12/20/02", "12/31/02").Working = False
End Sub
'Code end
'--------------------------------------------------------------------------

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[dotnet-force]

Hi,
Thank you for the answer, but ...

I already downloaded the Project 2002 SDK, otherwise I wouldn't be able
to develop my addin without that. But it is not suffisant because I'm
not able to get the description of the Period method that you give me
below which is necessary to use it. I assumed that the Start and Finish
argument was two dates but I didn't know if it was string or date or
something else.

So could you tell where you got this information and where I can access
to the description of all objects and methods included in the Project
2002 object model ?

Thanks you for your help.
Pascal Lenormand

 

[Wei-Dong Xu [MSFT]]

Hi Pascal,

Thank you for replying!

The reference documentation for Project VBA is located in %ProgramFiles%\Microsoft Office\Office10\1033 by default whose name is VBAPJ10.chm. If
you can't find it, you can check the project installation to see whether you have installed the "Visual basic for Applications" component. If not,
please add this component from the "Add/Remove programs".

Furthermore, I have tried to mail one zipped VBAPJ SDK to you(the mail address is "(e-mail address removed)"). However, your mail system told me that
this mail address didn't exist. I know this is one email address for these spam files. If you still can't find the SDK file, please tell me one correct email
address. I will mail the zipped SDK to you directly.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Pascal Lenormand]

Thank you because it's exactly what I need, the object, properties and
methods description.

I will send you my personnal adress so that you send me the VBAPJ SDK.
Once again thank you.

Pascal Lenormand
ILOG

 

[Wei-Dong Xu [MSFT]]

Hi Pascal,

Thank you for replying!

For preventing the spam mail, I add the online before Microsoft.com of my email address. If you mail to (e-mail address removed), I will not
receive the mail. For your convenience, I have mailed the SDK file to you at the email address: (e-mail address removed). If it is not your personal mail
address, please mail me at (e-mail address removed).

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.