none
VSTO Help needed for my Project RRS feed

  • Question

  • Does anyone know whether it is possible from vsto code to determine whether there is a formula or a lookup table attached to a user field like Text1 etc.? (I have developed my VSTO Project for MSProjects application)

     

     


    Dwipayan Das
    Monday, November 21, 2011 5:05 PM

Answers

  • Hello Dwipayan,

    Specifically with MSProject 2007 you are able to use all of the members of the PjField Enumeraiion. Here are the links to a chain of content that will give you a picture of those members.

    MSDN Library
    http://msdn.microsoft.com/en-us/library

    Project 2007
    http://msdn.microsoft.com/en-us/library/gg537300(v=office.12).aspx

    Project 2007 Developer Reference->Project Object Model Reference
    http://msdn.microsoft.com/en-us/library/bb244260(v=office.12).aspx

    PjField Enumeration
    http://msdn.microsoft.com/en-us/library/bb223192(v=office.12).aspx

    I do not see that the PjField Enumeration list contains a member with the name of ‘formula’ nor one with the name of ‘table’

    As a rule, if you can see the desired property in the list shown in the VBA Object Browser you can use the same property in a VSTO program.  You refer to the VBA Cell control in Excel. The properties and methods of MSProject Fields or Cells are not the same as those of Cells of Excel. You can see the MSProject object browser by opening the VBA editor and pressing the F2 key. There is a text box at the upper left area of the Browser window. Enter the word ‘field’ and click the button. Below that there is a window that lists all of the objects that contain the word ‘field.’  Select one of those and press enter. Below that is a window with two columns – members of the object and the properties, methods and events of that class.

    The PjField and PjCell enumerations for MSProject 2010 have more members.

    Please let us know whether this information answers your questions. Thanks.

    Regards,
    Chris Jensen
    Senior Technical Support Lead

    Wednesday, November 30, 2011 10:00 PM
    Moderator

All replies

  • Am i going in a wrong direction which is not feasible ???
    Dwipayan Das
    Tuesday, November 22, 2011 11:30 AM
  • Hi Dwipayan,

     

    Thanks for posting in the MSDN Forum.

     

    This is the correct forum to discuss your issue.

     

    Would you please answer me some question for further research?

     

    1.         You MSProject version.

    2.         Where is the Text1? Is it a windows form control, a VBA control or other things?

     

    Have a good day,

     

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, November 23, 2011 6:10 AM
    Moderator
  • Hi Tom,

    Thanks for your response.The MSProject version is 2007 ,Its a VBA Control (Like say Excel cell which is a VBA Control  but we can access the formula attached to it using inter op libarary),and my scenario is the similar in MSProject .

    Thanks,

    ---Dwipayan

     


    Dwipayan Das

    • Edited by Dwipayan Das Wednesday, November 23, 2011 7:43 AM More info
    Wednesday, November 23, 2011 7:40 AM
  • Hi Dwipayan,

     

    I’m not very family with the development of what your said. I will involve some experts into this thread to help you. There might be some time delay. Appreciate your patience.

     

    Have a good day,

     

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Friday, November 25, 2011 6:03 AM
    Moderator
  • Hello Dwipayan,

    Specifically with MSProject 2007 you are able to use all of the members of the PjField Enumeraiion. Here are the links to a chain of content that will give you a picture of those members.

    MSDN Library
    http://msdn.microsoft.com/en-us/library

    Project 2007
    http://msdn.microsoft.com/en-us/library/gg537300(v=office.12).aspx

    Project 2007 Developer Reference->Project Object Model Reference
    http://msdn.microsoft.com/en-us/library/bb244260(v=office.12).aspx

    PjField Enumeration
    http://msdn.microsoft.com/en-us/library/bb223192(v=office.12).aspx

    I do not see that the PjField Enumeration list contains a member with the name of ‘formula’ nor one with the name of ‘table’

    As a rule, if you can see the desired property in the list shown in the VBA Object Browser you can use the same property in a VSTO program.  You refer to the VBA Cell control in Excel. The properties and methods of MSProject Fields or Cells are not the same as those of Cells of Excel. You can see the MSProject object browser by opening the VBA editor and pressing the F2 key. There is a text box at the upper left area of the Browser window. Enter the word ‘field’ and click the button. Below that there is a window that lists all of the objects that contain the word ‘field.’  Select one of those and press enter. Below that is a window with two columns – members of the object and the properties, methods and events of that class.

    The PjField and PjCell enumerations for MSProject 2010 have more members.

    Please let us know whether this information answers your questions. Thanks.

    Regards,
    Chris Jensen
    Senior Technical Support Lead

    Wednesday, November 30, 2011 10:00 PM
    Moderator