Open Microsoft Project File

Posted on  by 

  1. Open Microsoft Project Files
  2. Open Microsoft Project File Viewer
  3. Open Microsoft Project Files In Different Windows
  4. Open Microsoft Project File In Excel
Recently I’ve been playing around on how to open a Microsoft Project file using Excel with VBA. This script should work at minimum for current versions of Microsoft Project. If you need it for an earlier version, it should be similar, so play around with the code.

Open Project files in Excel without Project installedCheck out my online courses more help visit my website http. A Microsoft Project viewer, also known as an MPP viewer, is a piece of software that gives users the ability to open, export and print MS Project files without a Microsoft Project license. It’s a life-saver for anyone using or receiving Microsoft Project files because of the many obstacles MS Project presents when it comes to sharing MPP files. You can go to Project client File Open Add a place Office 365 SharePoint to open the Project to check if the same problem will occur. You can also refer to this article: How to Add a Website to Trusted Sites to add your SharePoint site as a trusted site. When you work with Microsoft Project 2010 in 2 monitor, you finish working, save the file and then next day you open a project file and a blank screen appear like this: What the he., where is my project? At first I thought the file is damaged, but it isn’t. To show the project you go to View - Arrange All. And your project is back.

Start in Excel with VBA

You can build a procedure Sub in your VBA Editor after you add a new Module to your current workbook.

Before starting to write your code, make sure you have the right references to access Microsoft Project! Click on Tools>References>Microsoft Project xx.x Object Library. Then click okay.

Ready to Access Microsoft Project from Excel

Now you are ready to start coding in Excel to access information from Microsoft Project. Let’s start by opening a Microsoft Project file from Excel.

Make sure to first set up your variables, which in this script you only need one. You will need one variable for your MS Project application, which I called projApp.

Using Error Handling

Open Microsoft Project Files

I use the On Error Resume next in case MS Project is not installed and an error occurs. This way the code stops running and you don’t get an error. We set projApp to be a new instance of the object type. This means we can now access everything we need in MS Project.

NOTE: Every time you run a new Macro / VBA script you run a risk of losing all your work. When trying out new code I recommend you use it on copies of your projects and not on active projects. This way if your VBA doesn’t run correctly, you won’t lose valuable information. Run it at your own risk!

Where you see “C:<>My Example Project.mpp”, this is where you put the information on where YOUR file is located. I took out most of my file path to not make it confusing

Open Microsoft Project File Viewer

Of course, this is just the staring code where it just opens the Microsoft Project, you will need to write more code to do what you want it to do.

The last comment I want to make is that about the project file you might be trying to open. I have found that if your project file has macros, then you might have trouble using this macro because of Microsoft built in security. You might have to change the security settings so that your macro can work.

Otherwise, it works like a charm!

Open microsoft project file online

If you want to learn how to start with VBA, check out one of my posts on looping through tasks using the For Each…Next loop.

Learn Microsoft Project VBA

Project

VBA editor using the View tab or the Developer tab

Navigate the VBA Editor

  • Object Browser window
  • Project Explorer window
  • Toolbars
    • Standard toolbar
    • Edit toolbar
    • Debug toolbar
    • UserForm toolbar
    • Custom toolbar

Use Option Explicit

Use the message box (MsgBox) function

Open Microsoft Project Files In Different Windows

Project

Change the text of all tasks to all lowercase or all uppercase

How to open microsoft project file

Loop through tasks and resources using for each....next loops

Open

Open Microsoft Project File In Excel

Manually export VBA modules

Coments are closed