i would excel to open ms project extract all the data, and and place it in the open workbook. there is no need for linked items

Posted on 2009-02-24
Medium Priority
Last Modified: 2013-11-15
i need to extract, most of the data inside a ms project mpp, i would like to do it automatically, using vb, vba or a macro. where do i start?
Question by:j_wrieden
  • 4
  • 3
LVL 13

Expert Comment

ID: 23737182
The best answer depends on many variables:
When do you want this to happen? Does a user start the process?
Where do you need the results?

A macro running in Project could save the project to Excel or XML pretty easily. Do you need to do more than that?

James Fraser

Author Comment

ID: 23738321
hi thanks for getting back to me,

i would like to show the tasks, resources and fiscals, please tell me more about this macro.

there will around 1500 tasks,.

i need to tie the URIs together
tasks on one sheet, resources another and so on

LVL 13

Expert Comment

ID: 23738372
First look at the output you get from Project when you "Save As..." an Excel document and determine if that will meet your requirements.

If this includes what you want, you can then simply record a macro while you "Save As..." then edit that macro.

James Fraser
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.


Author Comment

ID: 23743550
i would like to control the 'save as' marco in project from excel.

basiclly i want excel to be the master and control what project does. i.e. save as a excel sheet and then close the msproject.

i am not sure of the best way to do it.

can i open project as an active project, use excel as to make project save with the neccery quallifiers?
LVL 13

Accepted Solution

jbfraser earned 1000 total points
ID: 23749318
Yes, you can do this.
1. Make sure you are comfortable with writing a macro in Excel. You should be comfortable with editting the VBA directly.
2. Make sure you are comfortable with the macro in Project. You will need to use parts of this in your Excel macro.

3. Set references to Project's Object Library.
4. Create an application object referring to Project in your Excel macro.
5. Use the object you created in #4 to call the Project VBA/macro commands. So if something was "SaveAs("blah", "blah")" in your macro from #2, you would now rewrite this in Excel as:
Dim ProjectApp as Project.Application
set ProjectApp = CreateObject("Project.Application")


(I typed the above directly into this message. I may not have the syntax exactly correct. This is meant to illustrate the basic idea of what you need to do.)

A reference for steps 3-5 can be found at
look for the section: "Activating Other Applications with Excel VBA" and the example of controlling PowerPoint.

Hope this helps...
James Fraser

Author Comment

ID: 23754210
hi james,

thank you for your sugestions.

i also added a .maptask to the save as. this works well.

once again thaks

LVL 13

Expert Comment

ID: 23756842
Don't forget to Accept an answer above.

James Fraser

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question