Ernst,
How are you currently doing this with the Excel files ?

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.