View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

You could shell it

Shell Application.Path & "\MSACCESS.EXE C:\MyDir\MyDatabase.mdb"
--

HTH

RP
(remove nothere from the email address if mailing direct)


"BMSpell" wrote in message
...
Good Morning
Can a macro be written under Excel to open an Access Database. I have

an
Excel worksheet that is kept open during the day to enter data. I would

like
to put a control button on the worksheet to execute a macro which would

open
an Access database found on the same network drive. The database is to be
use to enter alternate data. Any Ideas? Thanks.