PDA

View Full Version : Solved: Excel to Project



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.

paggers
05-08-2008, 01:27 AM
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