<div>
Check below thread out of Ron de Bruin, scroll down, and you find a nice solution:<br />
<a href="http://www.rondebruin.nl/exist.htm" rel="ugc">http://www.rondebruin.nl/exist.htm</a><br />
<br />
Or this thread:<br />
<a href="http://www.vbaexpress.com/kb/getarticle.php?kb_id=468" rel="ugc">http://www.vbaexpress.com/kb/getarticle.php?kb_id=468</a><br />
<br />
Hope this helps,<br />
Daniel
</div>


Check below thread out of Ron de Bruin, scroll down, and you find a nice solution:
http://www.rondebruin.nl/exist.htm [http://www.rondebruin.nl/exist.htm]

Or this thread:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=468 [http://www.vbaexpress.com/kb/getarticle.php?kb_id=468]

Hope this helps,
Daniel

<div>
Thanks Graham works perfectly<br />
<br />
danishani: Think the links you had effectively do the same thing but prefered the one Graham provided.
</div>


Thanks Graham works perfectly

danishani: Think the links you had effectively do the same thing but prefered the one Graham provided.

<div>
<div class="content wysiwyg-content">
I want to read/update information off an excel spreadsheet but don't want to do this while someone has it open. You cannot delete a file when someone has it open so system must record somewhere? - is there a way of finding out if a file is opened by someone - this file will be on a network drive. I looked on the FileSystemObject but could not see anything obvious to tell me.
</div>
</div>


I want to read/update information off an excel spreadsheet but don't want to do this while someone has it open. You cannot delete a file when someone has it open so system must record somewhere? - is there a way of finding out if a file is opened by someone - this file will be on a network drive. I looked on the FileSystemObject but could not see anything obvious to tell me.

In Access vba detect whether an excel file is open

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.