move excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i move an excel workbook from one folder to another?

thanks for your help
 
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...
 
thanks for your help

Stuart McCall said:
FileCopy "C:\OldFolder\MyWorkbook.xls", "C:\NewFolder\MyWorkbook.xls"
Kill "C:\OldFolder\MyWorkbook.xls"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
Merge Multiple workbook sheets into one workbook 0
Paste Excel Charts in PowerPoint as Linked Objects 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Import Several Excel Workbooks; Create Several Tables 11
Excel VBA 0

Back
Top