type mismatch, can't open a workbook?
I don't know why you can't just open a workbook why do you have to set it to
an object?
Is it because it is the open object? It is a little weird to think like that.
"Dave Peterson" wrote:
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
|