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, based upon this template.
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.