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
2
votes
0 answers

Call VBA Ms Project function from Matlab

I'm trying to gather a Ms Project tasks' durations from Matlab through a VBA function. The idea is to gather all durations in an array (variant in VBA), and then transfer this variable to matlab by calling a function. The VBA code includes a…
2
votes
2 answers

Where to find Microsoft Project interop tutorial or File Format Specification?

Anyone got a good tutorial for Microsoft Project interop (preferrably in C# or F#) or documentation and explanation of the file format used? Context: I'm trying to bridge the gap between a planning tool and Microsoft Project and basically just want…
Rune FS
  • 21,497
  • 7
  • 62
  • 96
2
votes
1 answer

How can I ensure that the "details" task pane in microsoft project vba is NOT displayed

I have an application in Microsoft project that performs a Backtrace of a task and then uses the following to save that image to an Excel Tab Application.EditCopyPicture Object:=False, ForPrinter:=0, SelectedRows:=0, FromDate:=EarliestStart,…
dgr
  • 57
  • 5
2
votes
1 answer

How can I add text automatically from text in another column in ms-project using VBA code

i have column Mold number(Text5) and i want to add automatically text for Product Name(Text2) For example if Mold number(Text5) = 111 , Product Name(Text2) "Trapez" will be created automatically And this is my code Sub AddProductName() Dim Name As…
2
votes
1 answer

How to Set Flag field to Yes or No Based on Text input - Microsoft-Project-VBA

I am trying to automate creating flag field based on if text is in the task description. The goal is to use text to search through the project file and for each row with the text, in a flag field to put yes beside it. I am able to generate a list…
boxue
  • 51
  • 7
2
votes
0 answers

Connect to specific Project Server Site and Project using MS Project Object Model

Note: I have resolved the error issue with winproj.exe opening throwing errors. This issue is no longer an issue for me. I have essentially solved most of this issue by updating the property Embedded IntroOp Types to false in…
Don
  • 21
  • 2
2
votes
2 answers

How do I set up Azure DevOps project for a VSTO add-in?

I have a Microsoft Project VSTO add-in that works with SharePoint Online and an Azure SQL database. Different customers would be hooking to seperate SharePoint tenants and using a different database, but all the power users would need the add-in.…
Eric Christoph
  • 348
  • 1
  • 12
2
votes
1 answer

How to display umlauts with VBA?

I'm writing a macro in MS Project. In a form I'm using Date and Time Picker control. And I have to use German locale. The problem is in the point that VBA doesn't display umlauts correct and März looks like Mдrz in the Calendar. I have problem with…
Shalaieva
  • 21
  • 2
2
votes
1 answer

Document Export failing in ms-project vba

I have code that prints specific views to pdf using a specific fromDate and ToDate. My code started failing when I updated to ms Project 2016. Any ideas? I've even tried removing the FromDate and ToDate and still get the error. When I add a watch…
2
votes
1 answer

How do I use pywin32 to extract data from task usage in msproject?

I am trying to use pywin32 Python Library to extract data from MSProject .mpp file to an excel file where I want my employees to register their work hour. I can extract data from any field I want except the Task Usage Table where it shows for every…
Tim
  • 59
  • 5
2
votes
1 answer

Setting page layout in MS-project from VBA script

I am working on a script that generates a MS-project plan from inside of excel. All is working fine but I have trouble setting the header and footer. It looks like I need to identify the view name, but I constantly get a runtime error 1101 or some…
2
votes
1 answer

Create MS Project XML file in C#

I'd like to create projects and tasks in XML format to MS Project. I've got the schema, and generated the classes from that(Project, Task, Resources, etc.), I can serialize it, but I'dont know the way what properties I need. I tried it manually, but…
user678182
  • 21
  • 1
  • 3
2
votes
1 answer

Library Reference Issues, VBA Excel 16.0, Project 14.0

My client recently migrated from 32-bit Excel 2016 to 64-bit Excel under Office 365 and retained 32-bit MS Project Standard 2010. I have VBA code native to MS Project Standard 2010 which manipulates the Excel 2016 Application by early binding via…
2
votes
1 answer

How to get MSP subproject statusdate in a masterplan from Excel VBA

I am building an Excel dashboard which I want it to get data from my department MSP Masterplan. So far I managed to get all data I want except the statusdate of subprojects. Sub ImportMSPData() Dim r As Range Dim MSP As MSProject.Application Dim…
2
votes
4 answers

Simple way to find max level 1 WBS and put all Level 2 WBS into array?

I can't seem to find anything about how I might do this from the documentation. My question basically has it all. I need the max WBS level 1 value as an integer, and then to loop through all its level2 subtasks/summaries and put a couple of their…
joshhemphill
  • 492
  • 6
  • 20