File in use

[Fred]

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

 

[Bob Phillips]

Fred,

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


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

http://support.microsoft.com/default.aspx?scid=kb;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)

 

[Tom Ogilvy]

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