View Full Version : Identify the write mode of a workbook
MaayanSV
04-13-2010, 12:48 AM
Hi All,
Is it possible to find a workbook is available for editing. (in other words, how to find a workbook is currently used by other users) without opening the file.
With Regards,
maayan:banghead:
Aussiebear
04-13-2010, 01:49 AM
You could use another workbook to count the number of times the initial (target)workbook was opened. Is that what you are after?
MaayanSV
04-13-2010, 02:23 AM
This is my requirement.
i wanted to write some data to a workbook without opening it through a script.
problem is multiple user access this file, we cannot add data if this file is used to by other users.
we cannot share this file, process restrict it.
can help?:help
Hi All,
Is it possible to find a workbook is available for editing. (in other words, how to find a workbook is currently used by other users) without opening the file.
With Regards,
maayan:banghead:
Try:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=468
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.