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!
Any help would be gratefully received!
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!