Hi all,
I have a button with a code to save on SharePoint (SaveAs) and it all works fine.
When the process is done and the user wants to close the workbook, the system would ask if they want to save it (it shouldn’t ask as the file is just saved and no changes been done since then?) and when the user clicks yes, it would ask if they want to keep their version or server version.
When saving to SharePoint using VBA, how do I get Excel to treat it as a normal save, so that it won’t ask me to save again or it won’t ask if I want to keep mine or server’s version? At the moment, Excel thinks I never saved the file and that it wasn’t me who updated the server version.
I have a button with a code to save on SharePoint (SaveAs) and it all works fine.
When the process is done and the user wants to close the workbook, the system would ask if they want to save it (it shouldn’t ask as the file is just saved and no changes been done since then?) and when the user clicks yes, it would ask if they want to keep their version or server version.
When saving to SharePoint using VBA, how do I get Excel to treat it as a normal save, so that it won’t ask me to save again or it won’t ask if I want to keep mine or server’s version? At the moment, Excel thinks I never saved the file and that it wasn’t me who updated the server version.
Last edited:
