It's a long time ago but I believe you need to try GetObject first (which is like create object but gets an open instance), add error trapping so that if that fails you know it's closed and can open it. if it''s open, you can close it then open it.
It's a long time ago but I believe you need to try GetObject first (which is like create object but gets an open instance), add error trapping so that if that fails you know it's closed and can open it. if it''s open, you can close it then open it.