+ Reply to Thread
Results 1 to 2 of 2

Need to know who has excel file locked

  1. #1
    sala@datacom.co.nz
    Guest

    Need to know who has excel file locked

    Hey there peoples ,

    Need help. I know if you click on a excel spreadsheet and it has been
    locked for editing by someone else a dialog box displays showing who
    has it locked. I have a access application where I open a excel file
    using VB. Is there a way to capture who has the excel file locked using
    VB . In fact retreiving the same information that displays in the "File
    locked for editing" that excel displays

    Thanks
    Sala


  2. #2
    Gary Keramidas
    Guest

    Re: Need to know who has excel file locked

    if you open the file as read only, you shouldn't see that message. unless you
    have some other reason for wanting to know.

    something like this:

    Workbooks.Open Filename:=fpath & fname, _
    ReadOnly:=True, UpdateLinks:=3

    --


    Gary


    <sala@datacom.co.nz> wrote in message
    news:1142976520.382446.12210@i39g2000cwa.googlegroups.com...
    > Hey there peoples ,
    >
    > Need help. I know if you click on a excel spreadsheet and it has been
    > locked for editing by someone else a dialog box displays showing who
    > has it locked. I have a access application where I open a excel file
    > using VB. Is there a way to capture who has the excel file locked using
    > VB . In fact retreiving the same information that displays in the "File
    > locked for editing" that excel displays
    >
    > Thanks
    > Sala
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1