If when connecting a shared drive, you get System Error 53 has occurred, The network path was not found, follow the solutions mentioned here.

Fix Runtime Error 76, Path not found VBA error in Excel that occurs when Excel tries to access a file and cannot find it, by implementing the following suggestions.