Menu
  • HOME
  • TAGS

Global variable losing it's value after Project is closed

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...

How to automatically update dates in past tasks based on the start date on a task in MS Project

project-management,ms-project

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....

Error importing XML file into MS Project

java,xml,ms-project

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"));...

Can you track subcontractor costs in MS Project?

ms-project

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...

Does Microsoft Project use OpenXML?

.net,.net-4.0,openxml,openxml-sdk,ms-project

No, OpenXML only describes the file format used by Microsoft Word, Excel and PowerPoint.

Microsoft Project releationship VBA code

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...

Will MS Project 2003 plugin support MS Project 2013?

ms-office,add-in,ms-project

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...

VBA excel Assigning resources to a task in MS Project

excel-vba,ms-project

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...

Iterate through Resource Graph view and export to XPS with resources name in VBA Microsoft Project 2010

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...

DateDifference in C#

c#,vsto,ms-project

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...

Slow VBA macro writing in cells

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 error when creating MS Project

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 ...