Get row number from a closed workbook

[mana]

Sub test2()
     Dim s As String
     s = "PRO123456"
     ' Cells(1).Formula = "=Iferror(match(""" & s & """,'Q:\KUNDER\PROJEKTER\HPG\[HPG_DB.xlsx]Template_0'!$A:$A,0),""not found"")"
End Sub