Open Access Database under and Excel window using a Macro

B

BMSpell

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.
 
B

Bob Phillips

You could shell it

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

HTH

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

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