VB Macro export .mpp to .mpp

[Bubba]

I am trying to create a macro tool to export only certain columns from a
Project 2007 file into a brand new Project 2007 file. For this reason I can't
use the built in MS project export function.

Here's the scenario: Many of the customers for the projects I manage are
requesting a project schedule as a .mpp file. They won't accept a PDF. I keep
propietary information such as costs, budgets, resource fields, etc. that I
do not want to share with them.

I would like to write some script in a VB macro to export only certain
fields such as 'TaskName', 'Predecessors', 'Start', 'Finish', and 'Work' etc
into a new .mpp file. The new .mpp file should maintian the task outline
formatting and timephased hours to match the original.

Currently at the customers request I have to copy and paste my file, then
spend a lot of time removing cost and resource information before emailig
them the file. Any help is greatly appreciated, thanks!

 

[Rod Gill]

Hi,

I think the best thing for the macro to do is save as to a new file, then
delete the information you want to hide rather than build from scratch.

I would also save a baseline so you can check at the end of the process that
dates haven't changed.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

I am trying to create a macro tool to export only certain columns from a
Project 2007 file into a brand new Project 2007 file. For this reason I
can't
use the built in MS project export function.

Here's the scenario: Many of the customers for the projects I manage are
requesting a project schedule as a .mpp file. They won't accept a PDF. I
keep
propietary information such as costs, budgets, resource fields, etc. that
I
do not want to share with them.

I would like to write some script in a VB macro to export only certain
fields such as 'TaskName', 'Predecessors', 'Start', 'Finish', and 'Work'
etc
into a new .mpp file. The new .mpp file should maintian the task outline
formatting and timephased hours to match the original.

Currently at the customers request I have to copy and paste my file, then
spend a lot of time removing cost and resource information before emailig
them the file. Any help is greatly appreciated, thanks!

__________ Information from ESET Smart Security, version of virus
signature database 5064 (20100427) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5064 (20100427) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Bubba]

Rob,

Thanks for the reply. Unfortunately I am using on the order of 30 custom
fields I would have to remove from every project each time I wanted to
export. This makes writing a macro to delete fields more difficult than
writing script to simply export 5-8 fields to a new .mpp file.

My thought was I would read from my current project the 5-8 fields I need to
export and store this data into array(s), then have script to create a new
file and write the arrays to the new .mpp file. I have trained a macro when
creating a new file to see the code, but this doesn't appear very stable if
I'm going to use this macro often.

Thanks!