VBA Save/Move file to new location

VBA Save/Move file to new location

Save/Move file to new location. PriorFileLocation is where the file is currently stored and NewFileLocation is where you want the file to be saved/moved to.

 

PriorFileLocation = "X:\MyDrive\FI Matrix.xlsx"
 NewFileLocation = "Z:\Dylan\FI Matrix2.xlsx"
 Name PriorFileLocation As NewFileLocation