Ernst,
By "mdb file is open", do you mean "Is any other user accessing the data " ?

The Excel concept of "Open" does not really apply to Access databases. What
are you trying to achieve ?

NickHK

"Ernst Guckel" wrote in message
...
Hey,

I have a spreadsheet that has a list of files in it that I test to see
if
it is open and if not I open the file. Then on to the next one. The
problem
is that I now need to add a database to the list.

I want to parse the list and if the file is a xls:
Open it if not already
& if a mdb open it if not already...

Is there a way to test if a mdb file is open from within excel? and how
do
I open the file from within excel?

Ernst.