| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repost: Is Workbook already open?
This is a repost from 4 days ago. I have searched the discussion group but my
original question seems to have vanished. Is there any code I can use in my macros to establish if a certain workbook is already open by another user on our network, regardless if it is "read only" or not? Any help would be appreciated. GrantW |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Repost: Is Workbook already open?
Frederik answered your post on the 7th... "Have a look at http://www.j-walk.com/ss/excel/tips/tip54.htm a great source of inspiration!!! greetz" --- Jim Cone adds... Outlook Express is a better way to read and write newsgroup posts... see: http://www.michaelstevenstech.com/ou...snewreader.htm or http://www.tushar-mehta.com/misc_tutorials/oe_ng/ -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GrantW" wrote in message This is a repost from 4 days ago. I have searched the discussion group but my original question seems to have vanished. Is there any code I can use in my macros to establish if a certain workbook is already open by another user on our network, regardless if it is "read only" or not? Any help would be appreciated. GrantW |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Repost: Is Workbook already open?
Thanks for finding his reply,Jim..... I must be having a "seniors day" :)
Also, thanks for the Outlook tip "Jim Cone" wrote: Frederik answered your post on the 7th... "Have a look at http://www.j-walk.com/ss/excel/tips/tip54.htm a great source of inspiration!!! greetz" --- Jim Cone adds... Outlook Express is a better way to read and write newsgroup posts... see: http://www.michaelstevenstech.com/ou...snewreader.htm or http://www.tushar-mehta.com/misc_tutorials/oe_ng/ -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "GrantW" wrote in message This is a repost from 4 days ago. I have searched the discussion group but my original question seems to have vanished. Is there any code I can use in my macros to establish if a certain workbook is already open by another user on our network, regardless if it is "read only" or not? Any help would be appreciated. GrantW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repost: open multiple instances of Excel | Excel Discussion (Misc queries) | |||
| Repost:Synchronizing two sheets within the same workbook | Excel Discussion (Misc queries) | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| Repost Excel Crashes on Workbook close!! | Excel Programming | |||
Linear Mode
