http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=291295
XL2002: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com?kbid=184982
WD97: VBA Function to Check If File or Document Is Open

--
Regards,
Tom Ogilvy


"Fred" <leavemealone@home wrote in message
...
I open a number of other workbooks to coolect and alter data but sometimes
one or more of those workbooks are in use by another user. If it is in use
then I would like to just skip that workbook.

How can I test to check if the workbook is in use before I try to open it?

Thanks for any help
Fred