Hi, I'm experiencing a problem with Excel in the Windows 7 environment. It appears that sometimes I temporarily lose connection to the network, and if I'm running any VBA procedures that are trying to save an Excel file to the network, they simply stop and wait for the user to click "Cancel" to the prompt message to save the file (if I click on it manually, the file gets saved). Is there an easy way to solve this automatically? I was told it's a Windows 7 issue and there are no solutions to it from the network administration stand point. So, I was thinking about setting up a time limit during which if the file is not saved to try it again - hopefully the network connection comes back in a few seconds. Or if there's a way to automatically click "Cancel" to that prompt (like "Click Yes" program for Outlook). Other ideas are definitely welcome. Thanks!
Last edited:
