Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Displaying File in Use By Info with vba

Hi

Do you know how to get the information to display who's using the file but only using vba

Thanks in Advanc

Shai
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 292
Default Displaying File in Use By Info with vba

Hi Shai

Open it by code and read the WriteReservedBy property of the file. This may
or may not work, depending on "how the network is built", I haven't found
better explanations on this.

HTH. Best wishes Harald

"s0mistr" skrev i melding
...
Hi,

Do you know how to get the information to display who's using the file but

only using vba.

Thanks in Advance

Shai



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying File Timestamp of Another Excel File [email protected] Links and Linking in Excel 3 July 23rd 08 06:06 PM
matching key fields between two workbooks and displaying info when tukky142 Excel Worksheet Functions 2 April 10th 07 08:40 PM
Displaying info in a new tab in excel Khamul Excel Worksheet Functions 4 August 16th 05 06:18 AM
Extracting info from word and displaying in an excel spreadsheet Drew Excel Discussion (Misc queries) 0 March 7th 05 03:49 AM
Displaying info John Excel Programming 0 August 25th 03 01:55 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"