Open Excel from Access

[DPThomas]

I am looking for a way to open a specific Excel workbook, over a network connection from a button click in Access. The problem being on top of not figuring out how to open the path file is, the Excel workbook imports the data from the access database that the button will reside in, so at some point after the excel workbook opens the database needs to close. I am not even sure if this can be done, but figured I would ask the experts. path to excel file is \\randy\lradata\masters\styles.xls if this helps

Thanks for your time

 

[spacepro]

add the following code on the onclick event of the button using the code editor.

Shell "excel.exe \\randy\lradata\masters\styles.xls ",vbnormalfocus   '  Opens Specified file
Docmd.Quit   'Close Database

Hope this helps

Andy