open an Application (excel) in a form using docmd

  • Thread starter Thread starter smason
  • Start date Start date
S

smason

Hello

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

thanks in advance
 
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....
 
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!
 
Try using the wizard to place a command button on the form.....

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