C
Chad
Is there a method to detect if a file is already in use by someone, before I
open it?
Chad
open it?
Chad
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Kilmer
Any particular kind of file?
C
Chad
Let's start with just Excel spreadsheets for now.
chad
chad
S
Seth
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
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
D
Dave Peterson
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138621
XL: Macro Code to Check Whether a File Is Already Open
XL: Macro Code to Check Whether a File Is Already Open