Can you please tell me whether it is possible to copy files (regardless of
type) from one location to another using VBA - I know how to get the
contents of a folder but can not find anything regarding actions to take on
files

Thanks

OrigFile="C:\video.wmv"
DestFile="D:\TEMP\copy of video.wmv"
FileCopy OrigFile, DestFile

Regards,
KL

"TAM" wrote in message
. uk...
Can you please tell me whether it is possible to copy files (regardless of
type) from one location to another using VBA - I know how to get the
contents of a folder but can not find anything regarding actions to take
on
files

Thanks

Many thanks for your help - works great

"TAM" wrote in message
. uk...
Can you please tell me whether it is possible to copy files (regardless of
type) from one location to another using VBA - I know how to get the
contents of a folder but can not find anything regarding actions to take
on
files

Thanks

Yes, it does, and (SURPRISE!) you could have found that by going to VBA Help
and typing 'file copy' (without the quotes) in the search box <g.


On Sat, 19 Feb 2005 17:25:00 GMT, "TAM" wrote:

Many thanks for your help - works great

"TAM" wrote in message
.uk...
Can you please tell me whether it is possible to copy files (regardless of
type) from one location to another using VBA - I know how to get the
contents of a folder but can not find anything regarding actions to take
on
files

Thanks