title: How do I specify a path in the worksheet.add command?
body: <p>I'm relatively new to programming in VBA. I want to insert a template into my worksheets. I Already have this code right now that works for the first step:</p>
  
  <pre><code>Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
  
      If Target.Column = 2 Or 3 Or 4 Or 5 Then
      Worksheets.Add after:=Worksheets(Worksheets.Count)
      Worksheets(Worksheets.Count).Name = Target
   End If
  End Sub
  </code></pre>
  
  <p>I know if you want to insert a template these are the steps: 
  Expression: .Add(Before, After, Count, Type)</p>
  
  <p>Type specifies the sheet type. Can be one of the following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. If you are inserting a sheet based on an existing template, specify the path to the template. The default value is xlWorksheet.</p>
  
  <p>I really need to link type to my Projectonderdelen.xltm, located in C:\Users\stage\Documents\Aangepaste Office-sjablonen</p>
  
  <p>Can anyone help me from this agony please?</p>
  
  <p>Greetings, Brendon</p>