Solved

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

Posted on 2004-03-22
3
249 Views
Last Modified: 2013-12-24
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?
0
Comment
Question by:g118481
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Accepted Solution

by:
M256 earned 200 total points
ID: 10652742
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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question