Consulting

Results 1 to 2 of 2

Thread: Solved: Excel to Project

  1. #1
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    3
    Location

    Solved: Excel to Project

    I am in the process of creating an application to transfer data from Excel to Project (Office 2003).
    I have managed to create the MS project file & transfer data from Excel to the relevant task & resource fields.
    I should point out that I am doing all this from VB code in Excel, all kicked off from a command button on the Excel sheet.
    I have now come up against a brick wall!!
    How do I show a new column in the Project Task Page? The column I want to show and transfer data to is 'Fixed Costs'.
    It seems to me I need to use .TableFields.Add but cant seem to get the syntax right.
    Any help would be much appreciated.

  2. #2
    VBAX Newbie
    Joined
    Mar 2008
    Posts
    3
    Location
    Well I've sus'ed it out myself eventually.
    The syntax is:
    pjApp.TableEdit Name:="", TaskTable:=True, NewName:="", FieldName:="", NewFieldName:="Fixed Cost", Title:="", Width:=10, Align:=2, ShowInMenu:=True, LockFirstColumn:=True, DateFormat:=255, RowHeight:=1, ColumnPosition:=6, AlignTitle:=1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •