Im having problems getting the programming correct using an Access Form as a
front end to open an Excel Workbook. The workbook is already is in place, but
the customer wants Access for the front end.
My problem is I cant figure out how to set the "on open properties" for the
workbook.
I need to have the have a worksheet open maximized, and I want to hide all
toolbars.

Below is the code I have set to call Excel.
I have used the send keys to answer the system message about opening a
hyperlink.



Private Sub Command0_Click()

Dim xlApp As Object
Dim FleNme As String
FleNme = "L:OFFICE SKILLS\FRONT END - DATA ENTRY.xls"
Set xlApp = CreateObject("Excel.Application")
SendKeys "{LEFT}{ENTER}"
'xlApp.Open "L:OFFICE SKILLS\FRONT END - DATA ENTRY.xls"
Set xlApp = Nothing ' set the reference to nothing

End Sub