>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
Your question is in the wrong Forum But for your problem, It can be related to the command:
xl.application.open "c:\test.xls"
Test this:
xl.application.open("c:\test.xls")