How about:

Public Sub openFile()
Const fName As String = "Book1.xls"
Const fPath As String = "MacOS X:SSP Folder:"
Dim wkb As Workbook
Set wkb = workbooks.open(filename:=fPath & fName)
end sub



Janis wrote:

i can't get this workbook to open. The folder, and filename is constant.
Thanks,

Public Sub openFile()
Const fName As String = "Book1.xls"
Const fPath As String = "MacOS X:SSP Folder:"
Dim wkb As Workbook
Set wkb = fPath & fName
wkb.Open

End Sub

--

Dave Peterson