Use the following in which myFileOpen is True if a valid file was selected
and opened, else False.

Dim myFileOpen as Boolean
myFileOpen = Application.Dialogs(xlDialogOpen).Show


--

Regards,
Nigel




"MattE" wrote in message
...
From within my excel VBA code I need to open another spreadsheet so am
using OpenFileDialog (unless there is there a better way?) but can't
get it to be recognized. What reference do I need to add for the file
dialogs?