paggers
03-25-2008, 06:25 AM
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.
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.