Export from MS Project on Schedule

[Eugene Martovoy]

Hi. I have such kind of a problem. Is there a way to automatical export data
from MS Project, so I can it in a budgeting system, for example.
May be export on schedule.

 

[John]

Hi. I have such kind of a problem. Is there a way to automatical export data
from MS Project, so I can it in a budgeting system, for example.
May be export on schedule.

Eugene,
It depends on what application you are exporting to and what kind of
data you need to export. For example, Project already supports several
export formats. You can see what they are by going to File/Save As and
looking at the formats in the "Save as Type" selection box at the bottom
of the "Save As" window.

However, export maps only work for static data. For timescaled data you
will need either VBA or SQL on the Project Database.

Either of the above can be initiated with an auto-run macro if desired.
If you want more details I suggest you post to our sister newsgroup,
microsoft.public.project.developer.

John
Project MVP

 

[Eugene Martovoy]

Thank you for the information, John.
I'll try to be more specific. I need to export data from MS Project into
Tab-delimited files, so I can use it in Cognos Contributor.
Of course, our system administrator can expot in manually (via "Save as"),
but I think that it is a kind of wrong thing to do.
Macro would be a good solution but I'm not strong in programming

 

[John]

Thank you for the information, John.
I'll try to be more specific. I need to export data from MS Project into
Tab-delimited files, so I can use it in Cognos Contributor.
Of course, our system administrator can expot in manually (via "Save as"),
but I think that it is a kind of wrong thing to do.
Macro would be a good solution but I'm not strong in programming

Eugene,
If you can do what you need manually, then you can record a macro of
those actions. Then, if you want to automate that macro, for example,
every time the file is opened or closed, set up your recorded macro to
auto-run on file open or close. For information on how to set that up,
go to fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
Read the information on running "on Open and other events".

If you want to learn more about VBA, (it opens up a whole new world of
options for you), I'll give you two resources. One is a free set of
tutorials on VBA which you can find on our MVP website at:
http://www.mvps.org/project/links.htm
Look for the link at the bottom of the page for, "Project 98 Visual
Basic Environment Training Materials". The second is an excellent book
dedicated exclusively to Project VBA that just came out. You can get the
book at: www.projectvbabook.com

John
Project MVP