is there a way to open a file in macro where the user
selects the file...like opens the "open file dialogue box"

something like
Sub Macro1()

Workbooks.Open Filename:= _
"C:\Documents and Settings\test.xls _
UpdateLinks:=0
End Sub

but the file name can be chosen by the use?
thanks