Saving in Multiple Locations (Microsoft Excel)

You may have a need to routinely copy a workbook to multiple locations on your system. For instance, the open workbook may need to be copied to a local hard drive and to several mapped drives that are actually on your office network.Excel doesn’t have a built-in capability to do this, but if the various locations are well defined, you can create a macro that will do the saving for you. The following macro is an example of such a tool:Sub SaveToLocations() Dim OrigName As String OrigName = ActiveWorkbook.FullName ActiveWorkbook.SaveAs “G:\” + ActiveWorkbook.Name ActiveWorkbook.SaveAs “L:\” + ActiveWorkbook.Name ActiveWorkbook.SaveAs “K:\” + ActiveWorkbook.Name ActiveWorkbook.SaveAs “S:\” + ActiveWorkbook.Name ActiveWorkbook.SaveAs OrigNameEnd Sub

Source: Saving in Multiple Locations (Microsoft Excel)

Advertisements

About David Lindsay Jr

David Lindsay is the author of "The Tay Son Rebellion, Historical Fiction of Eighteenth- Century Vietnam," that covers a bloody civil war from 1770 to 1802. Find more about it at TheTaySonRebellion.com, also known as, DavidLindsayJr.com. David Lindsay is currently writing about Climate Change and the Sixth Extinction., as well as singing and performing a "folk concert" on Climate Change and the Sixth Extinction. He can be reached at daljr37(at)gmail.com.
This entry was posted in Computer Tips and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s