Close workboook if it is open

[Guest]

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!

 

[Guest]

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.

 

[Frederik]

Hello Arne

Have a look at

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

Walkenbach gives interesting tips on his site!!!

greetings