check with access-vba if excel-file is currently open

zigi · Feb 5, 2004

hello,

i need some advice on how to check with ms-access-vba, if an excel-file (example "c:\testfile.xls") is currently open on the local pc

i would be very grateful for any help

thanks
zigi

Jonathan West · Feb 6, 2004

Hi zigi,

Take a look at this article

How to check if a file has already been opened by another user
http://word.mvps.org/FAQs/MacrosVBA/CheckIfFileOpen.htm

--
Regards
Jonathan West - Word MVP
http://www.multilinker.com
Please reply to the newsgroup

zigi said:
hello,

i need some advice on how to check with ms-access-vba, if an excel-file

(example "c:\testfile.xls") is currently open on the local pc?