How to Save workbook to multiple locations at once in excel

In this advanced excel tutorial you are going to learn how to save a workbook to multiple locations at once in excel using Microsoft Excel Vba. There are times when you need to save files to multiple location so that one kept intact and the other you can work with.

Sometimes we save an Excel workbook to multiple folder of our computer for security reasons also. We even save files at different places like flash drive and computer for mobility. Keeping all those in mind i have created this advanced tutorial How to Save workbook to multiple locations at once in excel. Hello, I'm your trainer Kazi and you are Watching Excel 10 Tutorial.

Remember we are going to save one workbook to two location in this demonstration using Vba and excel 2019. If you need to save one workbook to multiple location you can still do that with this tutorial. Lets get started.
Step 1: Click on the developer tab.
Step 2: Click on visual basic
Step 3: Click insert and than module
Step 5: Click on Run Button.
Done you have saved the workbook to your preferred locations.

#SaveWorkbook #MultipleLocation
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[atulmonga]

Thank you for your support your videos are really very good. The content is very useful to us in Excel. Thanks once again

[mauricelee]

Very nice video and also very helpful. Thank you very much for sharing this video.

[farukdrubo]

Thank you Mr. Kazi for this good tutorial.
When we use USB memory stick in different computers the USB drive letter change, in that case how to write the VBA code for changeable USB drive letter?
Kind regards.

[steprajs]

Its is nice one.
Still i have one prob. I am getting pop that do you want replace it.
is there any trick to avoid and replace it automatically ?

[jacksco]

Dear .thank u so match sir .
Than please with out VB used.
Save the two location pls tel me

[savds]

Hey thanks, how can i auto run the code everytime i save the workbook or do i need to open visual basic every time to run the code ?

[atulmonga]

Thanks for teaching us please share the code