Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if file is open
Is there a method to detect if a file is already in use by someone, before I
open it? Chad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if file is open
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if file is open
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if file is open
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect if file is open
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detect open-state of xls from outside Excel | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) |