Opening Excel from the switchboard

[Michelle]

I need to open an Excel spreadsheet from a switchboard
button. Is there any way to do this?

Thanks,
Michelle

 

[Ken Snell]

Yes. You could use code similar to this in the OnClick event of the
switchboard button:

Private Sub cmdButtonName_Click()
Dim xlApplication As Object
Set xlApplication = CreateObject("Excel.Application")
xlApplication.Visible = True
End Sub

 

[Arvin Meyer]

How about using ShellExcecute code:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Raistlin]

Yes. You could use code similar to this in the OnClick event of the
switchboard button:

Private Sub cmdButtonName_Click()
Dim xlApplication As Object
Set xlApplication = CreateObject("Excel.Application")
xlApplication.Visible = True
End Sub

You could also trythe following as the On Click code :


Private Sub cmdButtonName_Click()

Call Shell("C:\PathToExcel\Excel.exe""C:\PathToMyExcelFile.xls""", 1)

End Sub


You need to put the full path to the Excel.exe file in along with the full
path to your spreadsheet. Leave the quotation marks where they are and that
will deal with any spaces in the path names.

HTH

Raist.