How to determine if an excel file is open and who has it open ?

[sebpas]

I'm running an access program that updates 2 excel files with results from sql queries. I would like to know how to determine if either of the excel file is open and if so, who has it open. That way I can inform the user of the access program with a msgbox who's the guilty one.
I've seen it done before, just don't know wich language and methods they used.
Thanks

 

[scking]

You could probably find out if it is open by trying to open it and trapping the error but finding out who has opened it on the network is not possible from Access. There may be a Windows call that would provide you with that and you can write the code in Access. Maybe you should as on a Windows programming newsgroup.

Steve King Professional growth follows a healthy professional curiosity