VB- how to save offline file to server when computer is online

[szl14l]

I have written a Excel VB to save a file to sharepoint from an automated task. It works fine if it is connected to office network. If I am offline , I save the file to local drive . Can somebody help to guide me for the macro to save the file to sharepoint when computer is connected to office network? My office does not recommend checking the network status continuously. Any suggestions will be appreciated

Regards
szl14l

 

[xenou]

A typical strategy in a case like this is to attempt to save the file to your sharepoint location. If it works, good, and if it doesn't work, then save locally instead.