Office Integration
Hi all,
is there a way to develop team project independent Excel Templates? MS Project allows to define a template that can be imported by the process template. In Excel, I'm also allowed to import a template but without a predefined set of work item columns.
Thank you
Stephan
I'm not completely sure I understand, so I'll tell what I know is possible. It is possible is to create an excel workbook (xls file) and associate it with a query during project creation. This is what is being done for the 'Project Checklist.xls' file that you see in the Documents\Project Management node in the Team Explorer, for example. What happens is that during project creation the 'WSS' task will take the .xls file you specify and add to it the name of the server, the name of the project, and the GUID of the query to run. When that file is opened in Excel it connects to the server/project and creates a new list object in the upper left corner of the active worksheet.
You can see how this is done by downloading the process template and looking at the WssTasks.xml file. Search for 'Project Checklist.xls' in that file and notice the 'queryId' attribute. Setting that attribute causes the document to be associated with that query. This also works on .mpp files.
