ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   workbook open - microsoft solution - current user vs other users (https://www.excelbanter.com/excel-programming/412402-workbook-open-microsoft-solution-current-user-vs-other-users.html)

PBcorn

workbook open - microsoft solution - current user vs other users
 
in response to a previous topic regarding testing to see if a workbook is open:

"Tom Ogilvy" wrote:


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



What i want to know is whether these will also allow for the workbook being
kept open by the current user as well as other users.


All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com