Copy Single file to multiple destination in easy way...?

[miqbal]

Hi,

I want to backup my log workbook to multiple locations. How can i do it in simple way.?

right now i only back to one location and here is my code. I am not a programmer but by seeing different posts i created this "sub".


[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Sub BackupTaskInfo()[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
FileCopy "X:\Startup\Tasks Info_2018.xlsx", "U:\Tasks Report\Tasks Info_2018.xlsx"[/FONT]
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]
End Sub[/FONT]


the above copy file to only 1 location "U:\Tasks Report" but I want to save it 2nd location also which is "U:\Backup".

 

[Special-K99]

No VBA expert but if the above works
just repeat the FileCopy line of code within the sub with and supply a different destination

 

[Joe4]

Just add a second similar line under the first one, i.e.

[B]FileCopy "X:\Startup\Tasks Info_2018.xlsx", "U:\Backup\Tasks Info_2018.xlsx"[/B]

 

[miqbal]

Thnx

 

[miqbal]

I thought there will be function like FileCopy whicb i can use to add multiple destinations in a single line of code.. but thnx alot the above suggestion of pros works great.

 

[Joe4]

I thought there will be function like FileCopy whicb i can use to add multiple destinations in a single line of code

I don't think there is, though you could create your own function (UDF) in VBA to do it.
That might be worth it if you were going to re-use it a bunch of time in your code, but if it is only to copy over one file two teams, I would say it really isn't worth the extra effort.