TemplateRemoveExtData Property Example

This example saves the workbook as a template that contains no external data.

With ThisWorkbook
    .TemplateRemoveExtData = True
    .SaveAs "current", xlTemplate
    .TemplateRemoveExtData = False
End With