how to paste with text format using vba?

[jaik22]

Range("A:B").Select
Selection.Copy
Template.Activate
  Columns("S:T").Select
    Selection.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
        False

Column A,B are from a different workbook, and I would like to paste with text format.
However, that formula does not work. Is there any other ways to solve this issue?

 

[mikerickson]

Perhaps

With Template.Range("S:T")
    .NumberFormat = "@"
   .Value = ActiveSheet.Range("A:B").Value
End With