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?