I am trying to open the MS Excel Application from a Command Button in Access.

the Code I am using is

Private Sub MicrosoftExcel_Click()

     Dim App As Object
     Set App = CreateObject(“excel.Application”)
     App.Visible = True

End Sub

When clicking on the Command Button, I can see Excel start to run in the taskbar, but it immediately closes.  I have no problem starting Word using

Private Sub MicrosoftWord_Click()

     Dim App As Object
     Set App = CreateObject(“Word.Application”)
     App.Visible = True
End Sub

Anyone have any suggestions?

​I am trying to open the MS Excel Application from a Command Button in Access. the Code I am using isPrivate Sub MicrosoftExcel_Click()     Dim App As Object     Set App = CreateObject(“excel.Application”)     App.Visible = TrueEnd Sub When clicking on the Command Button, I can see Excel start to run in the taskbar, but it immediately closes.  I have no problem starting Word usingPrivate Sub MicrosoftWord_Click()     Dim App As Object     Set App = CreateObject(“Word.Application”)     App.Visible = TrueEnd Sub Anyone have any suggestions?   Read More

​