how do i open up a file knowing the first part of the filename in excel using vba

See how next code can help, customize Constantes to your need

Sub Test()
Const WkPath = "C:\Users\user\Downloads\"
Const StFN = "70000"
Dim DIR_Result  As String

    DIR_Result = Dir(WkPath & StFN & "*", vbNormal)
    If (DIR_Result <> "") Then _
    Workbooks.Open Filename:=WkPath & DIR_Result
End Sub

Maybe this:

Option Explicit

Sub Test()
Dim flNm As String
flNm = InputBox("What is the Job Code?")
Const WkPath = "F:\folder\subfolder\" 

Dim DIR_Result  As String

    DIR_Result = Dir(WkPath & flNm & "*", vbNormal)
    If (DIR_Result <> "") Then _
    Workbooks.Open Filename:=WkPath & DIR_Result
    End if
End Sub

amended code. See post 4 again.

awesome!!!! It worked great!! Thank you!!!

In post 4, I would suggest to remove

    End if

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.