NEWBIE Alert! Macro Run at workbook Startup

Hello all,

I am attempting to get the following macro stored in a workbook to start when the .xlt is opened. I have no idea where to begin or how to do it, any help would be greatly appreciated.

Public Function NextSeqNumber(Optional sFileName As String, Optional nSeqNumber As Long = -1) As Long
Const sDEFAULT_PATH As String = "\\tpadc\intranet\Plot Ticket"
Const sDEFAULT_FNAME As String = "defaultseq.txt"
Dim nFileNumber As Long

nFileNumber = FreeFile
If sFileName = "" Then sFileName = sDEFAULT_FNAME
If InStr(sFileName, Application.PathSeparator) = 0 Then _
sFileName = sDEFAULT_PATH & Application.PathSeparator & sFileName
If nSeqNumber = -1& Then
If Dir(sFileName) <> "" Then
Open sFileName For Input As nFileNumber
Input #nFileNumber, nSeqNumber
nSeqNumber = nSeqNumber + 1&
Close nFileNumber
Else
nSeqNumber = 1&
End If
End If
On Error GoTo PathError
Open sFileName For Output As nFileNumber
On Error GoTo 0
Print #nFileNumber, nSeqNumber
Close nFileNumber
NextSeqNumber = nSeqNumber
Exit Function
PathError:
NextSeqNumber = -1&
End Function


Public Sub SetUpNewClient()
With ThisWorkbook.Sheets(1)
.Range("V58").Value = NextSeqNumber
End With
End Sub

You need to name the macro Auto_Open.

Keep in mind that the macro security level should be medium or low.

Nevermind, I found what I was looking for!