open an Application (excel) in a form using docmd

S

smason

Hello

can i open an Application (excel) in a form using docmd
can this be done if so how??

thanks in advance
 
A

Albert D. Kallal

If you just want to open the other document, be it pdf, doc (word), or xls,
(excel), then just go:

application.FollowHyperlink "c:\path name\documentname"

eg:

application.FollowHyperlink "c:\mySheets\sales.xls"

The above command launches the document as if you double clicked on it to
open it....
 
S

Steve

Hello !

i not sure i explained properly in my intial question! i am looking to just
open excel (the program) as apossed to a particular document! using a button
on a form

any ideas!
 
A

Albert D. Kallal

Try using the wizard to place a command button on the form.....

It has a option to launch excel.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top