Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BMSpell
 
Posts: n/a
Default 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.


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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"