Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Detection of Workbook already Open
I have a workbook that runs on a network and wish to
intercept if any user has the file open. At the moment the standard Excel message appears with the option to open it read only etc. My intention is prevent users from doing anything if the workbook is already open, display a message to this effect and then close the file. TIA Nigel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Detection of Workbook already Open
these show you how to check:
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 -- Regards, Tom Ogilvy "Nigel" wrote in message ... I have a workbook that runs on a network and wish to intercept if any user has the file open. At the moment the standard Excel message appears with the option to open it read only etc. My intention is prevent users from doing anything if the workbook is already open, display a message to this effect and then close the file. TIA Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
Directory and File Detection | Excel Discussion (Misc queries) | |||
Color detection | Excel Worksheet Functions | |||
Detection of VBA code | Excel Programming |