XL2002: Macro Code to Check Whether a File Is Already Open (291295)
The information in this article applies to:
This article was previously published under Q291295 For a Microsoft Excel 2000 version of this article, see 213383.
For a Microsoft Excel 98 and earlier version of this article, see 138621.
SUMMARY
When you use a file that is shared over a network, you may frequently find it useful to know if another user has the file open. The following Microsoft Visual Basic for Applications procedure is an example of a method for determining whether another user has a particular file open.
REFERENCES
For more information about how to use the sample code in this article, click
the article number below to view the article in the Microsoft Knowledge
Base:
290140
OFFXP: How to Run Sample Code from Knowledge Base Articles
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB291295 |
---|
|