Checking if any Excel file open by another user or on my PC from VBA?

[VBAguy22]

Hi
Is there a way to check if a file on a network drive, say
H:\Common\file1.xls open by anyone?
I remember IsOpen in Java but not sure how VB handles this

 

[SkipVought]

Hi,

Take a look at the FileSystemsObject...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsfsotutor.asp

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}