Calling project from excel

[Aubrey]

I'm using project 98 and excel 97.

I'm using a macro to pick up the row number in excel and
then open MS Project. I'm trying to pass the row number
to the auto_open macro in Project. I either can't get the
auto_open macro to run or it ignores the row number I'm
trying to pass to it as a variable. Any ideas? The codes
is
IN EXCEL
Public tcpNo As Integer 'tcpNo = MS Project Number

Public Sub createNewProject()
tcpNo = ActiveCell.Row

Application.ActivateMicrosoftApp xlMicrosoftProject

FileOpen Name:="d:\Process\4Dep\NewTemplateTry.mpp",
ReadOnly:=False
End Sub

IN MS Project
Sub auto_open(ByVal tcpNo As Integer)

SetTaskField Field:="Text4", Value:= tcpNo

Stop

End Sub