Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

boldHow to determine who has an excel 2000 file open

Status
Not open for further replies.

sebpas

IS-IT--Management
Mar 30, 2001
39
CA
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 (with locks)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




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top