Forum Discussion

MichaelB200's avatar
MichaelB200
Copper Contributor
Oct 30, 2024
Solved

Opening Excel from an Access Command Button

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("exce...
access
  • arnel_gp's avatar
    arnel_gp
    Oct 31, 2024

    MichaelB200 , you Add a Workbook so it will stay open:

     

    Private Sub MicrosoftExcel_Click()

     Dim App As Object
     Set App = CreateObject("excel.Application")
     
     'arnelgp
     App.Workbooks.Add
     
     App.Visible = True

End Sub
arnel_gp's avatar
arnel_gp
Iron Contributor
Oct 31, 2024

MichaelB200 , you Add a Workbook so it will stay open:

 

Private Sub MicrosoftExcel_Click()

     Dim App As Object
     Set App = CreateObject("excel.Application")
     
     'arnelgp
     App.Workbooks.Add
     
     App.Visible = True

End Sub

Resources