General information
Category:
Coding, syntax & commands
Title:
Opening an Excel Sheet Object
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only