Shortcut to open Excell App

[jk]

Hello,

I have asked around and tried but continue to hit a wall
on what is probably a simple thing.The command button that
Access provides for a form has an option to open excell.It
opens a workbook but the user has to find the file by
using the file open command.Is there a way to create a
short cut so when a user clicks the command button, it
automatically opens an existing sheet.For
example::hedgehogs.xls??
Thanks for any assistance....

 

[Dan Artuso]

Hi,
This may be a matter of semantics but...
An Excel file such as hedgehogs.xls is a workbook with a
collection of Worksheets. Are you saying that your present code opens up
a blank Workbook?
This code, (assuming hedgehogs.xls is on the root of C will open the file:
Application.FollowHyperlink "C:\hedgehogs.xls"

 

[Guest]

Thanks Dan,

What i am saying is that going through the steps of the
command button results in a workbook being opened but not
displaying a sheet.You have to go and find or open a
file...i just want to have the workbook open and display a
sheet automatically...thanks

-----Original Message-----
Hi,
This may be a matter of semantics but...
An Excel file such as hedgehogs.xls is a workbook with a
collection of Worksheets. Are you saying that your present code opens up
a blank Workbook?
This code, (assuming hedgehogs.xls is on the root of C will open the file:
Application.FollowHyperlink "C:\hedgehogs.xls"

--
HTH
Dan Artuso, Access MVP


"jk" <[email protected]> wrote in

message news:[email protected]...

 

[Dan Artuso]

Hi,
The code in my previous post will do what you want.