open excel file automaticallty via access btn

[BankGirl]

hi i am trying to open a excel spreadsheet automatically at the push of a button. i am using the below code that i obtained via another help message but i keep getting an error message saying 'runtime error 5, invalid procedure or call arguement???

can someone help me out?

Private Sub cmdOpenExcelFile_Click()
Dim stAppName As String

stAppName = "h:\sue\bdrm\FBT Fleet\access\FBTDataFleetCollection.xls"

Call Shell(stAppName, 1)

End Sub

[Jim Doherty]

Try the application.followhyperlink method instead

 
Dim stAppName as string
stAppName = "h:\sue\bdrm\FBT Fleet\access\FBTDataFleetCollection.xls"
application.FollowHyperlink stAppName
 

Regards

Jim

[Stewart Ross]

hi i am trying to open a excel spreadsheet automatically at the push of a button. i am using the below code that i obtained via another help message but i keep getting an error message saying 'runtime error 5, invalid procedure or call arguement???

can someone help me out?

Private Sub cmdOpenExcelFile_Click()
Dim stAppName As String

stAppName = "h:\sue\bdrm\FBT Fleet\access\FBTDataFleetCollection.xls"

Call Shell(stAppName, 1)

End Sub

Hi. Shell needs to know what application to launch - try this in place of your Call statement

Call Shell ("Excel " & stAppName, 1)

It works for me.

Cheers

Stewart