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
[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]