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" <(E-Mail Removed)> schreef in bericht
news:FC95413D-660A-466F-BF3F-(E-Mail Removed)...
> 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!