Questions tagged [ms-project]

Microsoft Project is a tool to help plan projects and track progress against that plan

Microsoft Project is a software tool for planning projects at granular level and tracking progress against that plan. You can:

  • plan projects
  • create teams
  • create resources and manage their working time
  • manage tasks and allocations of resources to tasks
  • create timesheets
  • track work progress (actuals)
  • track project costs

and much more in a single intuitive interface.

This tag is for programming questions related to the use of . General questions about MS Project use should be referred to superuser.com.

Links:

999 questions
3
votes
2 answers

MPXJ: get planned work via API

I want to extract the planned work over the time from MS Project using MPXJ. Does anyone know how to get these figures via API? I cannot find any appropriate method for doing this. (Concrete scenario: I want to draw a chart with the planned work on…
Philipp
  • 383
  • 5
  • 20
3
votes
0 answers

OfficeJS Office.context.document.getTaskFieldAsync fails on some important fields

I'm blocked with calling getTaskFieldAsync API to read some fields required for my solution. Expected Behavior getTaskFieldAsync must successfully return field value for valid task ID Current Behavior getTaskFieldAsync returns error: { code: [1,2],…
3
votes
3 answers

Color coding tasks in a Microsoft Project Macro

This seems like it should be straight forward, but I'm seeing some strange behavior. I'm attempting to color code my tasks based on a flag. It appears to be correctly coloring the tasks, but at some point in the processing the initial tasks that…
Shawn
  • 196
  • 1
  • 2
  • 13
3
votes
0 answers

How to connect to Microsoft Project Online using python

I have hundreds of projects hosted on Microsoft Project Online and I want to perform the analysis using Python. How to connect to Microsoft Project Online? Currently I am using PowerBI but I am not liking it and want to use Python for the analysis.
3
votes
1 answer

MS Project (*.mpp file) to PowerBi

I need to import data from MS-project (*.mpp file) to PowerBi. I need free solution. So I cannot use MS Project Server I try to do it with Python. But it has many problems and it is complicated to extend it. There is code what I use in PowerBi: …
3
votes
1 answer

Loop through all TableFields in Microsoft Project add to combobox

I'm stuck trying to create a UserForm in VBA with a combobox that lists all possible TableFields(?). Updated code: Using the code provided by @dbmitch and some freestyle. This lists a two-column combobox with both the Original and the Custom field…
Doons
  • 183
  • 11
3
votes
2 answers

How do I automatically create Summary and Subtasks in Microsoft Project using VBA

So I have a Timeline in Microsoft Excel which contains a variety of information. I created an array of my own custom type which read in this data but now I need to output my array onto Project. My array consists of a custom datatype as…
rebel360
  • 31
  • 3
3
votes
1 answer

Print to PDF with Microsoft Print to PDF printer

I try to print a ms project file to pdf without any additional action needed. I have tried several solutions without success. PrintDocument doc = new PrintDocument() { //DocumentName = safeDir + fileName, PrinterSettings = new PrinterSettings() …
ket0ma
  • 81
  • 2
  • 7
3
votes
3 answers

MS Project: Loop through filtered tasks

From a MS-Project I'd like to copy to an excel sheet the task names that meet the criteria of a filter. Let's say filter dumb tasks. I was trying something but it's not working: Dim b As Task For Each b In ActiveProject.TaskFilters("dumb tasks") …
peetman
  • 669
  • 2
  • 15
  • 30
3
votes
1 answer

Developing add-ons/extensions for MS Project

I would like to write a quick UI addon for MS Project, but I don't know how to proceed. Ideally it should be fully integrated into Project. Just need to know how to get started. Thanks!
aduric
3
votes
1 answer

How to SelectRow of a Task in Sub-Project (inside a Master-Project)

I have a Master-Project, and inside it I have several Sub-Projects. I want to format the Color of the Rows based on a value of a field Text5. Current Problem: How to use VBA code to refer to the Row in the 2nd Sub-Project. When I run the code, and I…
Shai Rado
  • 33,032
  • 6
  • 29
  • 51
3
votes
1 answer

Example of MPXJ library in C#

I'm having a heckuva time finding any C# code examples using the MPXJ library when connecting to a Microsoft Project file. Can someone please post a snippet demonstrating how to write the contents of a table in an .mpp file to screen? Bonus points…
Daniel Szabo
  • 7,181
  • 6
  • 48
  • 65
3
votes
1 answer

VBA Copy Paste Data into Excel from Project

I'm running the code below and getting spurious results. For some reason it copies five lines of code into the desired worksheet instead of the specified MS Project data. Can Anyone help out a newbie? Five lines of code incorrectly copied into…
ERKSMTY
  • 135
  • 3
  • 13
3
votes
3 answers

How to Improve Performance when Loading Data into Microsoft Project with VSTO

Background We have an existing application which can load data into Microsoft Project so it can be manipulated by MS Project. The original application is an old-style COM Project add-in written by VB6 targeting on MS Project 2003 / 2007, and now we…
Zhe Yang
  • 45
  • 5
3
votes
2 answers

How to iterate all rows and columns through a loop in MS project

Am working on Ms project file and currently am having trouble in below two areas 1) Now am trying to iterate all rows and columns through a loop for ex:- Task ResourcesName Start products xxxx 10/3/2017 projects yyyy …
vineeth vp
  • 45
  • 1
  • 7
1 2
3
66 67