Is there a method to detect if a file is already in use by someone, before I
open it?

Chad

Any particular kind of file?

"Chad" wrote in message
...
Is there a method to detect if a file is already in use by someone, before
I
open it?

Chad

Let's start with just Excel spreadsheets for now.

chad


"Bob Kilmer" wrote in message
...
Any particular kind of file?

"Chad" wrote in message
...
Is there a method to detect if a file is already in use by someone,
before
I
open it?

Chad

Just use this function:

Function IsWorkbookOpen(WorkbookName as String) As Boolean
Dim Wkb as Workbook
on error resume next
Set Wkb = Workbooks(WorkbookName)
If Not Wkb Is Nothing Then IsWorkbookOpen = True
End Function


Just have to pass the workbook name to the function...if
it is open, it will return TRUE, if it is closed, FALSE

Seth

-----Original Message-----
Is there a method to detect if a file is already in use
by someone, before I
open it?

Chad


.

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

Chad wrote:

Is there a method to detect if a file is already in use by someone, before I
open it?

Chad

--

Dave Peterson