Are you attempting to retrieve data from that database for
use in your workbook? You can use something like ADO to do
that.

-----Original Message-----
While I'm working in a worksheet I want to open and view
an access
database file.
So far I've been able to open access by using this code:

Dim accApp
accApp = Shell("C:\Program Files\Microsoft
Office\Office\msaccess.exe",
vbMaximizedFocus)

But I want access to immediately open a database and this
I have been
unable to do.

I tried everything I could find on the internet, like

GetObject
Getfile
Run
Activate
Execute
etc.

Yet nothing I've tried does what I want.

Anybody help me, plz?!

Peer


---
Message posted from http://www.ExcelForum.com/

.