Problem when opening excel .xlsm file from Access button

[milovisk]

I have created a button to open an excel spreadsheet, if I run the code in the vba editor it opens the spreadsheet and displays it, however when I click the button it opens the spreadsheet but stays on the access page. I then need to click on the excel tab on the bottom of windows 7 to view the spreadsheet. Can anyone help in solving this problem.



Below is the event code assigned to the button

Sub Product_555x()
Dim appexcel As Object
Set appexcel = CreateObject("Excel.Application")
appexcel.workbooks.Open "c:/products/templates/Product 555x.xlsm"
appexcel.Visible = True



End Sub

[John_G]

Hi -

Is the form where you have the command button have the Modal property = True, or if opening with VBA, does the OpenForm command specify dialog mode when opening?

Either one could cause this issue.

HTH

John