I'm not much of a VB programmer, but it looks like your missing the workbooks object in your reference. Try:

xl.application.workbooks.open "c:\test.xls" 'valid file name

Tip: Whenever I'm having trouble with Office Automation, I go into the Office app and record a macro to do what it is I need to do, then look at the VB Script in the macro.


>Can someone tell me what is causing my open file code to fail with the error ' invalid object reference'
>
>Private Sub Command1_Click()
> Dim xl As Object
>
> Set xl = CreateObject("Excel.Sheet")
>
> xl.application.Visible = True
> xl.application.open "c:\test.xls" 'valid file name
> xl.Open "c:\temp.csv"
>
>
> Set xl = Nothing
>End Sub
>
>
>Thank you