asked on

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

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?

jbfraser

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

j_wrieden

ASKER

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

jbfraser

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

j_wrieden

ASKER

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?

ASKER CERTIFIED SOLUTION

jbfraser

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

j_wrieden

ASKER

hi james,

thank you for your sugestions.

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

once again thaks

jbfraser

Don't forget to Accept an answer above.

James Fraser