How to Open Excel to a specific file via Access Command Button?

[dohernan via AccessMonster.com]

I have a Form in Access with a few Command buttons to Excel spreadsheets.
All I want to do is have the user click a button and go to the Excel
spreadhseet they choose.
I'm not sure how to do that?

Thanks.

 

[fredg]

I have a Form in Access with a few Command buttons to Excel spreadsheets.
All I want to do is have the user click a button and go to the Excel
spreadhseet they choose.
I'm not sure how to do that?

Thanks.

"To the Excel spreadsheet they choose"?
How are we to know how they choose?

Code the click event of a command button:
Application.FollowHyperlink "PathToFile\ChosenFileName.xls"

 

[dohernan via AccessMonster.com]

"To the Excel spreadsheet they choose"?
How are we to know how they choose?

Code the click event of a command button:
Application.FollowHyperlink "PathToFile\ChosenFileName.xls"

Thanks, Hyperlink works perfectly.