Can Office save a file on multiple locations when i click SAVE Button RRS feed

  • Question

  • Hello,

    When i press save command in Office some times i need that file may be saved at multiple locations one at my local drive and one at a network location on my LAN.

    This can be very beneficial in case  my local hard drive crashes and work may be lost.


    Wednesday, March 26, 2014 6:05 AM


  • Hello Hassan,

    Microsoft Office applications doesn't provide such functionality out of the box. You need to save the in each place separately. However, you can develop a VBA macro or add-in for saving the file in multiple places according to your needs. The SaveAs2 method of the Document class can be used for saving a document at the specified place.

    Wednesday, March 26, 2014 7:38 PM