Hi vumian,

vumian wrote:
no man, i wrote above, it's just a example :))
atually, i'm not looking for a filename with extension "doc", just xls
only
but it has not worked so far , hixhix :(

i wanna check if that file is not opened,
how to msgbox for this ??
help me pls.

Your code should work - it does for me. For a workbook that has been saved
before, you should always use .xls at the end of the filename when you're
checking to see if it's part of the active Workbooks collection. So if you
have a workbook named filename.xls that you want to check for, you would use
gbIsWBOpen("filename.xls"), which will return True if the workbook is open
and False if it's not.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]