Access issues...

Associate
Joined
11 Mar 2005
Posts
1,168
Right - not really a problem - more of an inconvenience!

I'm using the following VBCode (automatically set with access) and want to know if I can amend it to open a specific file in excel. VB is not my forte as you can tell!

Code:
Private Sub Command41_Click()
On Error GoTo Err_Command41_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_Command41_Click:
    Exit Sub

Err_Command41_Click:
    MsgBox Err.Description
    Resume Exit_Command41_Click
    
End Sub

Any help would be gratefully received!
 
Back
Top Bottom