Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    checking if wbook is opened or free (2000 r s1)

    I use this macro to open a wbook, is possible to know if thsi wbook is opened from other user and know wich user have opened this?

    Sub open_wbook()

    Dim wb As Workbook
    Set wb = Workbooks.Open("d:user.xls")
    Windows(wb.Name).Visible = False

    End Sub

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: checking if wbook is opened or free (2000 r s1)

    Check out the code in this thread.Xtreme Visual Basic Talk - File Reservation - being modified by another user

    About halfway down is some code from Ivan F Moala which seems to work (it is dated "16 Apr 2004, 06:42 AM") but I have not tested it extensively...

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •