Open Access Database under and Excel window using a Macro
 

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.

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.