move excel workbook

[jnewl]

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

thanks for your help

[Stuart McCall]

"jnewl" <jn...@discussions.microsoft.com> wrote in message
news:B64B594F-BCC1-45BF...@microsoft.com...

> how do i move an excel workbook from one folder to another?
>
> thanks for your help

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Stuart McCall" <smc...@myunrealbox.com> wrote in message
news:fgtvej$p9i$1$8300...@news.demon.co.uk...

[jnewl]

thanks for your help

[jnewl]

thanks for your help