excel,vba,excel-vba,project,ms-project
You are adding references to objects when you add a Task to the Collection. These references only have meaning so long as the objects they refer to exist. Those objects are destroyed when the project is closed. If you want to use their data, you will need to copy it...
A task's scheduled start date is calculated using the following: relationships (e.g. predecessors) constraints (e.g. "Start No Earlier Than") calendars (e.g. which days are working days) If Task 11 has no predecessors and no constraints, it will default to start on the first working day after the project start date....
Maybe it is file encoding issue - the two files (one generated and one created manually) have different encoding. The first one is incorrect and the second one is correct. If that's the case, you should generate file with the right encoding. You could try: xmlOutput.output(doc, new OutputStreamWriter(new FileOutputStream(file), "ISO-8859-1"));...
The short answer is not directly, but you can make it work. MS Project does not support fixed costs based on resource. You can have fixed costs on tasks, but they won't be dependent on which resource is assigned (aka which contractor). That said, you can work around this limitation...
.net,.net-4.0,openxml,openxml-sdk,ms-project
No, OpenXML only describes the file format used by Microsoft Word, Excel and PowerPoint.
vba,tfs,ms-project,microsoft-project-vba
Well it was my own bad. I only tried to for testcases the first 5-10 Tasks/Backlogs. But for MS Project + Tfs you need to fix all "publish errors" to get the connections to work @tfs. Greetings Declade...
No, it won't. There is a slim chance that the core code may run ok, but with the switch from the menu bar to the ribbon menu, any menu options presented by the 2003 plug in won't be presented as buttons on the ribbon in 2013, so I can say...
Well I found a way how. This definitely isnt the best way, but after I added the resources in these lines: If Not ExistsInCollection(oPrj.Resources, strCrane) Then oPrj.Resources.Add.Name = strCrane If Not ExistsInCollection(oPrj.Resources, strForeman) Then oPrj.Resources.Add.Name = strForeman I then have to loop through the all the resources I have added...
vba,ms-office,ms-project,microsoft-project-vba
This is likely due to the Resource Graph being in a different sort order than the resources in the Resource collection. Instead of trying to sync those up, you can use the Find command to move the graph to the correct resource. Sub ResourcGraph() Dim Res As Resource ViewApply "Resource...
You can use the same exact MS Project VBA method in vsto. Change Application to your MSProject.Application variable name and preface ActiveProject with that variable. For example, if your variable name is ProjApp use this: differencedate = ProjApp.DateDifference(tsk.BaselineStart, tsk.BaselineFinish, ProjApp.ActiveProject.Calendar) The returned value will be the duration in minutes between...
excel,vba,excel-vba,ms-project
Would it be possible, to write in a whole row, instead of the single cells? Would that be faster? Yes and yes. This is exactly where you can improve performance. Reading/writing to cells is notoriously slow. It matters very little how many cells you are reading/writing, but rather how...
excel,vba,excel-vba,ms-project
You don't have any code that handles that error (at least not that you posted). One way is: Dim pjapp As Object On Error Resume Next Set pjapp = CreateObject("MSProject.Application") On Error Goto 0 If pjapp Is Nothing Then MsgBox "Project is not installed" End If ...