As in:

myFile = Application.GetOpenFilename("Excel Files,*.xls")

See OLH for GetOpenFilename Method


--
HTH
Roger
Shaftesbury (UK)


"doug" wrote in message
...
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