Copy help

[PCOR]

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

 

[Tom Ogilvy]

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 news:[email protected]...