Hi! I want to check if a workbook is open. If it is open I want to close it.
The probelm is that if I want to check if it is open and it is not the code
cannot find the sheet at all and thus produces an error. Is there any way I
can check if it is open without getting an error? thanks!

I use

Windows(cl).close savechanges = False

where cl is the workbook I want to close, I usually have an "On error resume
next" so that if the workbook isn't there it won't error when it can't close.

"Arne Hegefors" wrote:

Hi! I want to check if a workbook is open. If it is open I want to close it.
The probelm is that if I want to check if it is open and it is not the code
cannot find the sheet at all and thus produces an error. Is there any way I
can check if it is open without getting an error? thanks!

Hello Arne

Have a look at

http://www.j-walk.com/ss/excel/tips/tip54.htm

Walkenbach gives interesting tips on his site!!!

greetings


"Arne Hegefors" schreef in bericht
...
Hi! I want to check if a workbook is open. If it is open I want to close
it.
The probelm is that if I want to check if it is open and it is not the
code
cannot find the sheet at all and thus produces an error. Is there any way
I
can check if it is open without getting an error? thanks!