Working from home, I often need to connect to the server at work (on VPN), and open an excel file (Excel 2013).
I have a macro that automatically checks whether the VPN is connected - I wrote that because the VPN often drops out without my noticing, and if I try to open a file on the server, it thinks for half a minute before telling me it can't find the file, or words to that effect.
The problem is, I can't get it to check the VPN connection before it tries to open the file (so it still just sits). Is there a way to do that?
While we're at it, I'd also like to only check the VPN when I'm trying to open a file on the work server (which is mapped to my L: drive). Is there a way to do that?
Running Win7.
Many thanks.