Save to multiple locations

I am working on a spreadsheet, i need to have it to where it will save to 2 locations when the save button is pressed. Is there anyway possible of doing this?

Originally Posted by VBA Noob

Hi,

Does this help

Change the path to your 2nd path

Please Login or Register  to view this content.

Note this will overwrite any previous backup with the same name without warning

HTH

VBA Noob

Hi,
I want to do the same thing and i copied your code but it doesnt seem to work.

Private Sub Workbook_Save()
ActiveWorkbook.save
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs "\\wlgfile4\660305$\ACurrent Projects\AProject General Docs\" & ActiveWorkbook.Name
Application.DisplayAlerts = True
End Sub

i tried just putting in your codes (without private sub) but it also didnt work. As I am quite new to VBA, can you please oblige me by directing me to what i should do first?

thanks so much

Help please!
Tell me what i've done wrong... :-(

Originally Posted by VBA Noob

Are you sure the path is correct

Try recording the action

VBA Noob

Hi,

Yes. I tried other paths as well and it doesnt work.
I might just have to settle for the default save a back up.. :-(
thanks.