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...
Will MS Project 2003 plugin support MS Project 2013?
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...
DateDifference in C#
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...
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...
How to automatically update dates in past tasks based on the start date on a task in 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....
Can you track subcontractor costs in 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...
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...
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.
Error importing XML file into 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"));...
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 ...
VBA excel Assigning resources to a task in 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...
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...