move excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
jnewl said:
how do i move an excel workbook from one folder to another?

thanks for your help
Click to expand...

FileCopy "C:\OldFolder\MyWorkbook.xls", "C:\NewFolder\MyWorkbook.xls"
Kill "C:\OldFolder\MyWorkbook.xls"
 
Or, more simply,

Name "C:\OldFolder\MyWorkbook.xls" As "C:\NewFolder\MyWorkbook.xls"

(This will only work if the two folders are on the same drive. If they're on
different drives, you have to use the copy and delete approach)
 
thanks for your help

Douglas J. Steele said:
Or, more simply,

Name "C:\OldFolder\MyWorkbook.xls" As "C:\NewFolder\MyWorkbook.xls"

(This will only work if the two folders are on the same drive. If they're on
different drives, you have to use the copy and delete approach)
Click to expand...
 
Back
Top