MapEdit Method

Creates or edits an import/export map.

Syntax

expression**.MapEdit(Name, Create, OverwriteExisting, NewName, DataCategory, CategoryEnabled, TableName, FieldName, ExternalFieldName, ExportFilter, ImportMethod, MergeKey, HeaderRow, AssignmentData, TextDelimiter, TextFileOrigin, UseHtmlTemplate, TemplateFile, IncludeImage, ImageFile)**

*expression   *     Optional. An expression that returns an Application object.

Name    Required String. The name of the map to create, copy, or edit.

Create    Optional Boolean. True if Microsoft Office Project 2003 should create a new map. If NewName is not specified, the new map is given the name specified with Name. Otherwise, the new map is a copy of the map specified with Name and is given the name specified with NewName. The default value is False.

OverwriteExisting    Optional Boolean. True if an existing map should be overwritten with a new one. The default value is False.

NewName    Optional String. A new name for the existing map (Create is False) or the name for the new map copied from the existing map (Create is True). If NewName is not specified and Create is False, the map specified with Name retains its current name. The default value is Empty .

DataCategory    Optional Long. The category of data that will be modified by other arguments. Required if any of CategoryEnabled, TableName, FieldName, ExternalFieldName, ExportFilter, or MergeKey is specified. Can be one of the following PjDataCategories constants: pjMapTasks, pjMapResources, or pjMapAssignments.

CategoryEnabled    Optional Boolean. True if the map imports and exports the category of data specified with DataCategory. If Create is True and NewName is not specified, CategoryEnabled is set to True.

TableName    Optional String. The name of the external table or worksheet that the map imports data from or exports data to. The type of table is determined by the value of DataCategory. If Create is True and NewName is not specified, TableName is required.

FieldName    Optional String. The name of a field to add to the map. The field is mapped to the external field specified with ExternalFieldName. The type of field is determined by the value of DataCategory. If Create is True and NewName is not specified, FieldName is required.

ExternalFieldName    Optional String. The name of the external field to add to the map. The external field is mapped to the field specified with FieldName. If ExternalFieldName is not specified, the name specified with FieldName is also used for ExternalFieldName.

ExportFilter    Optional String. The name of the filter to use when exporting data. The type of filter is determined by the value of DataCategory. The default value is "All Tasks" when DataCategory is pjMapTasks, "All Resources" when DataCategory is pjMapResources, and ExportFilter is ignored when DataCategory is pjMapAssignments.

PjImportMethods

MergeKey    Optional String. The name of the Project field to use as a key when merging imported data. The field must exist and have already been added to the map. The type of field is determined by the value of DataCategory. If ImportMethod is pjImportMerge, MergeKey is required.

HeaderRow    Optional Boolean. True if a column header row should be created in the external file during an export and whether it exists in the external file during an import. If creating a headerless map (HeaderRow is False) that will be used to import the same data it exports, ExternalFieldName is required and must be a sequentially numbered value for each field exported, beginning with "1", to indicate its column position in the exported file. The default value is True.

AssignmentData    Optional Boolean. True if assignment rows should be included with exported resources and tasks. If True, assigned resources appear under each task in a task table and assigned tasks appear under each resource in a resource table. Data exported when AssignmentData is True cannot be imported by Project. The default value is False.

TextDelimiter    Optional String. The character to use as a field delimiter when importing data from a text file. The default value is a tab character.

TextFileOrigin    Optional Long. Specifies the character set under which a text file was created. Can be one of the following PjTextFileOrigin constants: pjTextOriginWin, pjTextOriginDOS (including OS/2), pjTextOriginUnicode, or pjTextOriginMac.

UseHtmlTemplate    Optional Boolean. True if an export to an HTML file will be based on an HTML template.

TemplateFile    Optional String. The HTML template file to use when exporting to HTML. If UseHtmlTemplate is True and the map specified with Name does not contain the name of an HTML template file, TemplateFile is required.

IncludeImage    Optional Boolean. True if a reference to an image file should be included when exporting to HTML. The default value is False.

ImageFile    Optional String. The name of an image file to include when exporting to HTML.

Example

The following example simply creates a map that allows the information on the default Gantt Chart to be exported and imported.

Sub MakeEntryTableMap()

    MapEdit Name:="Fields in the Gantt Chart View", Create:=True, OverwriteExisting:=True, _
        DataCategory:=pjMapTasks, CategoryEnabled:=True, TableName:="Task_Table", _
            FieldName:="ID", ExternalFieldName:="ID"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Name", ExternalFieldName:="Tasks"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Duration"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Start", ExternalFieldName:="Start_Date"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Finish", ExternalFieldName:="Finish_Date"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Predecessors"
    MapEdit Name:="Fields in the Gantt Chart View", DataCategory:=pjMapTasks, _
        FieldName:="Resource Names", ExternalFieldName:="Resources"
    
End Sub

Applies to | Application Object

See Also | FileOpen Method | FileSaveAs Method | MapList Property