Open Excel

[Guest]

What is the best way to open a specific excel file from an access form using
code. I cannot use the hyperlink, I would like the Excel file to open from my
code.

Thank you,

 

[Damon Heron]

the simplest way is the Shell code on the click event of a command button:
Dim FName As String
FName = "C:\my stuff\Test.xls"
Call Shell("Excel " & Chr$(34) & FName & Chr$(34), vbMaximizedFocus)

Damon

 

[fredg]

What is the best way to open a specific excel file from an access form using
code. I cannot use the hyperlink, I would like the Excel file to open from my
code.

Thank you,

Is:

Application.FollowHyperlink "C:\MyFolder\MySpreadsheet.xls"

the same as using hyperlink?
Or is it code?