[RESOLVED] How to Insert a row in Excel ?

[CVMichael]

I have an excel file with data from A1 to A10, how would I insert a row before lets say, Row 5 ?

I have this code:

Dim xlApp As Excel.Application
    Dim wkbTemplateBook As Excel.Workbook
    Dim wksTemplateSheet As Excel.Worksheet
    
    Set xlApp = New Excel.Application
    Set wkbTemplateBook = xlApp.Workbooks.Open(Me.txtTemplate.Text)
    Set wksTemplateSheet = wkbTemplateBook.Worksheets(1)
    
    With wksTemplateSheet
        ' how to insert a row ?
    End With