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

[zigi]

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]

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

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?