Run time error '1004' Workbook.Open

[abi_learn_vba]

Hi,

I have used a Userform to browse a file, and the file path in the textbox is saved to the variable "input", please see the code below. Then i called and procedure "ProcessInput" (Which is in Module) to open the file. But when the module is opened the Input value shows "empty" and it does not have the path name. But as i see the filename is saved in the variable "input" in "Private Sub cmdOK_Click() ". Can any one say if i am wrong in doing this?

Private Sub cmdOK_Click()
If Trim(TextBox1.Text) = "" then
    MsgBox "One or All Files are not Selected!! Try Again"
        Exit Sub
    End If
    Input = TextBox1.Text
    Call ProcesInput
    Unload Me
End Sub
 
Public Sub ProcesInput()
Set myfile = Workbooks.Open(Input)
End Sub

 

[VoG]

Try

Dim MyInput As String, myfile As Workbook
Private Sub cmdOK_Click()
If Trim(TextBox1.Text) = "" Then
    MsgBox "One or All Files are not Selected!! Try Again"
        Exit Sub
    End If
    MyInput = TextBox1.Text
    Call ProcesInput
    Unload Me
End Sub
 
Public Sub ProcesInput()
Set myfile = Workbooks.Open(MyInput)
End Sub

 

[abi_learn_vba]

Thanks a Lot...