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?

hi
using your method, you can select the file and click the open button. but if
that is too much of a hassel, then you would need to hard code the open file
into your code ie
Workbooks.Open Filename:="C:\your\file\path\thafile.xls"

regards
FSt1

"MattE" wrote:

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?

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?