open application to a specific doc with a cmd button

[mgm]

I would like to open an excel worksheet from an access form.. this is what
I've tried but it doesn't find the doc. This worked with access 97, but not
with 2000. Any help would be appreciated.

Private Sub Command25_Click()

Dim myApp As String
Dim myDoc As String

myApp = "excel.exe "
myDoc = "workflow.xls"
Shell myApp & myDoc, vbNormalFocus

 

[Allen Browne]

That approach should work if you specify the full path to execl.exe, and the
full path to the xls file, assuming Excel is install and permissions are
adequate.

It may be easier to use ShellExecute:
http://www.mvps.org/access/api/api0018.htm

 

[Guest]

Another alternative is to simply use Application.FollowHyperlink. It will
open any document (including excel workbooks) in the default application
associated with the document.

Application.FollowHyperlink Path&Filename
Application.FollowHyperlink "c:\workflow.xls" 'Use your fullpath