I store my files in c:\01 and wish to back them up to
I can do it by opening up each file and saving to that
location and then shutting the file down but I'm sure
there must be an easier way.
If there is a way could it be used to backup Word files as
Thanks as usual,
If you want to make a copy of the file you are
working on from within Excel see my bakup.htm page.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Rob Pearce" <ro...@talk21.com> wrote in message news:070d01c2c916$13c66db0$d4f82ecf@TK2MSFTNGXA11...
XCOPY c:\01\*.* d:\02\*.* /s /d
not XCOPY c:\01\*.* d\02\*.* /s /d
But at least I know you're familiar with XCOPY <grin>
"Robin Clay" <rC...@hasnospamwell.com> wrote ...
'// Demo: Dana DeLouis
Const From As String = "C:\01\*.*"
Const Destination As String = "D:\02"
CreateObject("Scripting.FileSystemObject").Copyfile From, Destination
Depending on what you want to do, you might want to work with something like
Const GetWord As String = "C:\01\*.DOC"
Const GetExcel As String = "C:\01\*.XLS"
Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"Rob Pearce" <ro...@talk21.com> wrote in message