Using excel vba how to check if file i just tried to save was actually saved to Sharepoint server location

Question

Hi, i am writing a macro where i save some output from the macro to a sharepoint server. I and a few other people will be using this macro and each of us will be saving output to the same sharepoint server location.

the problelm is i can save files to a sharepoint location that i have access to write data to but if i dont have write access or the path is wrong then the save is NOT done AND there is NO alert to let me know the save operation was not done. Now i have tried the error checking usual stuff but they dont seem to work. So my question is basically

"How can i know if when trying to save a file to a sharepoint location if the save operation actually worked and saved the file?"

Note: i am using excel vba to do this

note may sharepoint site is something like the following:

"https://ABC.sharepoint.com/sites/Johnson/Macro%20Usage%20Tracking/"

if you have any questions please let me know.