Open Access Database under and Excel window using a Macro

  • Thread starter Thread starter BMSpell
  • Start date Start date
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.
 
You could shell it

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

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Close all without saving and exit without prompts 8
Call Access macro using Excel VBA 1
Access Command to run access, open to specific form and specific record 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Insert subtotal in a query database Excel 2007 3
Formula, Macro, or VBA code to find and insert 3
Excel Excel Macro Help 0

Back
Top