P
Paul B
I know you can have Access open excel, but can you have it open a workbook
also, here is the code I get when you put a button on a from to do it
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim oApp As Object
Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
'***** can it open the workbook here??******
'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
Thanks
also, here is the code I get when you put a button on a from to do it
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim oApp As Object
Set oApp = CreateObject("Excel.Application")
oApp.Visible = True
'***** can it open the workbook here??******
'Only XL 97 supports UserControl Property
On Error Resume Next
oApp.UserControl = True
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
Thanks