Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get programmatically "file is locked .. " by whom?

Status
Not open for further replies.
rubinov

rubinov

IS-IT--Management
Feb 12, 2004
6
0
0
US
In manual mode when you try to open the file, the dialog "File in Use" appears having "File is locked by 'user name'" message.

I use Excel Automation to work with Excel files. When the file is opened by another user, then the file is opened as a read-only. In this situation I would like to get programmatically the user name by whom file is used.
Something like:

if NOT oExcel.Workbooks.CanCheckOut(filename)
'*get the user name, how?
....



Thanks in advance

Yuri Rubinov
 
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
95
ladyck3
ladyck3
cneill
  • Locked
  • Question
Hi, I am trying to get my head rou
2 3 4
Replies
64
Views
530
combo
combo
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
241
teknance
teknance
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
82
ladyck3
ladyck3
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
504
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top