Save Excel workbook in multiple locations
This tutorial shows how to save an Excel file in multiple locations at once using VBA
Sub Save_to_multiple_locations()
ThisWorkbook.SaveCopyAs "C:\Excel\" + ThisWorkbook.Name
ThisWorkbook.SaveCopyAs "C:\Tutorials\" + ThisWorkbook.Name
ThisWorkbook.SaveCopyAs "C:\Tutorials\" + ThisWorkbook.Name
End Sub
NOTES
Note 1: This VBA code will save an excel file in multiple locations at once that have been identified in the code.
Note 1: This VBA code will save an excel file in multiple locations at once that have been identified in the code.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Create and Save a new workbook | How to create and save a new workbook using VBA | |
| Save an Excel workbook | How to save an Excel workbook |