G Guest Nov 8, 2007 #1 how do i move an excel workbook from one folder to another? thanks for your help
S Stuart McCall Nov 8, 2007 #2 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"
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 Nov 8, 2007 #3 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)
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)
G Guest Nov 8, 2007 #4 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...
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...
G Guest Nov 8, 2007 #5 thanks for your help Stuart McCall said: FileCopy "C:\OldFolder\MyWorkbook.xls", "C:\NewFolder\MyWorkbook.xls" Kill "C:\OldFolder\MyWorkbook.xls" Click to expand...
thanks for your help Stuart McCall said: FileCopy "C:\OldFolder\MyWorkbook.xls", "C:\NewFolder\MyWorkbook.xls" Kill "C:\OldFolder\MyWorkbook.xls" Click to expand...
