look at the Filecopy command. The example from help:



Dim SourceFile, DestinationFile

' Define source file name.
SourceFile = "SRCFILE.xls"

' Define target file name.
DestinationFile = "DESTFILE.xls"

' Copy source to target.
FileCopy SourceFile, DestinationFile

--
Regards,
Tom Ogilvy


com wrote in message ...
Hi all
Using the function shown below I c an obtain the newest file in that
directory
=newestfile("c:\&dip2005\2005backup\","*.xls")
How can I now copy this file from its current location to a different
folder.
Many thanks
Ian M
--
Norton Professional 2004 says this email is clean...believe it