And yes I want to keep the form open. If I unload the form I can open
the file but I need to keep the form open as well.

sonu wrote:
Private Sub TB_ImportIntoBook_Enter()
'MsgBox "This is enter"

Openwkb = Application.GetOpenFilename("FileToImportInto, *.xls")

Workbooks.Open (Openwkb)

TB_ImportIntoBook.Value = Openwkb

End Sub

I have the above code in a form. This code is in a text box and runs
when users enter in the text box. I can not open excel fie. If I
comment out the like "Workbooks.Open (Openwkb)" the form work fine but
also does not open the file. I want the file to open also then user
selects the file.

Can anyone help me with this. Is this possible or I am trying to do
something that is not possible.

Please let me know

Regards

Sonu.