Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opened File
If you are looking to see if the workbook has been opened by someone else,
Tom Ogilvy posted this: ----------------------- You can open it and see if it is readonly, then you will know someone else is using it. You can also do: 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 --------------------------- "Combo" wrote in message ... Please help-me! Are there a function in VBA programming has return if a file of excel if already opeded by other user in my intranet? Tnks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
go last row when file is opened | Excel Discussion (Misc queries) | |||
file links incorrect when file is re-opened | Excel Worksheet Functions | |||
When was file last opened? | Excel Worksheet Functions | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions |