Solved: checking if a database is open

[philfer]

I want Excel to interact with an Access database but first I want to check if the particular database is open or not.

If it isnt I want to open it.

How do I do this

[Bob Phillips]

Why? You can interact with a closed database.

[philfer]

every time I try to do this it says

"ActiveX cannot create object"

[Bob Phillips]

Post the code.