In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened.
VBA Script
In this tutorial I will share a VBA Function (User-Defined Function) that can detect whether if a file is currently opened.
Some how this function does not work on network mapped drive.
In our company we have shared drive (say, letter S is shared drive letter for colleagues to share files) and I found this function couldn’t detect opened file under S.
If it’s network drive should also has address other like path “S:/” so try to find it out.
In my company we use \\xxxx and I use that in my code to save files/open them etc.