Create new MS Project files (.mpp) based on query?

Hi all,

I have a project plan template that I would like to do the following:

1.  run a query to my MS Access table for project numbers and project status fields
2.  create a new .mpp file for each project number in query 1
3.  change two fields in the new .mpp files to match the project numbers and project status fields from the query
4.  save the files on my local PC

(all work for this is done locally)

I have no idea of how to get started with this, except for the query.  So, I am looking for lots of help and code examples.

Is this possible using CF?
LVL 1
g118481Asked:
Who is Participating?
 
M256Connect With a Mentor Commented:
Hi g118481,

I am not familier with Microsoft Projected.  However, you may see if there is an option to "save as web page", or export in *.htm format.  If so, we can expect that it is possible to import one.  Try exporting it (if you have the option) and open it in Notepad.  This should give you and idea what kind of output you need.

If you get that figured out, you could either save it as a file with <cffile> or open it in Microsoft Project with the following:

<cfheader
  name="Content-Type"
  value="application/vnd.ms-project">
<cfheader
  name="Content-Disposition"
  value="attachment; filename=project.mpp">

I think this is correct, but I don't have Project to test it with.

Sorry I can't give you a complete answer, but I hope this is a starting place for you.

Matthew
0
All Courses

From novice to tech pro — start learning today.