how do I open a file in VB6

[bowz75]

I have the following command button on a menu, Excel launches, but how do I add a specific file (C:\My Documents\xxx.xls).

Private Sub Command32_Click()
On Error GoTo Err_Command32_Click

Dim oApp As Object

Set oApp = CreateObject ("Excel.Application")
oApp.Visible = True
'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True

Exit_Command32_Click:
Exit Sub

Err_Command32_Click:
MsgBox Err.Description
Resume Exit_Command32_Click

End Sub

 

[JerryKlmns]

Take a look on the Open method of Workbooks object of excel