how to detect if a .xls is in use

[Marc Miller]

Does anyone know how to dectect if an excel spreadsheet it in
use before using workbooks.open(path&file) ?

I can't seem to find anything in the search engines or help files
for this.

TIA,
Marc Miller

[solex]

Marc,

You could try to open the file using a filestream if it returns an in use
error you know it is currently opened by another process(Excel).

Dan

"Marc Miller" <mm****@hotmail.com> wrote in message
news:Od**************@TK2MSFTNGP15.phx.gbl...

Does anyone know how to dectect if an excel spreadsheet it in
use before using workbooks.open(path&file) ?

I can't seem to find anything in the search engines or help files
for this.

TIA,
Marc Miller