ReportTemplate.TemplateType property (Project)

Gets the Visual Report template type. Read-only PjVisualReportsTemplateType.

Syntax

expression. TemplateType

expression A variable that represents a ReportTemplate object.

Remarks

The TemplateType property can be one of the PjVisualReportsTemplateType constants.

Example

The following example lists all of the Visual Report template types and files for the current user.

Sub ListTemplatePaths() 

 Dim templateList As String 

 Dim typeOfTemplate As String 

 Dim template As ReportTemplate 

 

 For Each template In Application.VisualReportTemplateList 

 Select Case template.TemplateType 

 Case pjExcel 

 typeOfTemplate = "Excel" 

 Case pjVisioMetric 

 typeOfTemplate = "Visio Metric" 

 Case pjVisioUS 

 typeOfTemplate = "Visio U.S." 

 Case Else 

 End Select 

 

 templateList = templateList & vbCrLf & typeOfTemplate & ": " _ 

 & template.TemplatePath 

 Next template 

 

 MsgBox "Visual Reports Templates:" & templateList 

 

End Sub

See also

ReportTemplate Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.