File Handling

[TAM]

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

 

[KL]

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

Regards,
KL

 

[TAM]

Many thanks for your help - works great

 

[Myrna Larson]

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>.