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

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

Fred,

http://support.microsoft.com/default...b;EN-US;291295
XL2002: Macro Code to Check Whether a File Is Already Open


http://support.microsoft.com/default...b;EN-US;213383
XL2000: Macro Code to Check Whether a File Is Already Open

http://support.microsoft.com/default...b;EN-US;138621
Macro Code to Check Whether a File Is Already Open

Ms suggested way.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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