move excel workbook

S

Stuart McCall

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"
 
D

Douglas J. Steele

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)
 
J

jnewl

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...
 
Top