File management by VBA

[Excelboo2]

I have files in let say C:\Jan. Is it possible to write some scripts in VBA to copy some files (which is specified in Sheet1 of an excel file) to let say C:\Feb. Thanks

 

[Andrew Poulsom]

Check out the FileCopy statement in VBA Help. Example:

FileCopy "C:\Jan\MyFile.xls", "C:\Feb\MyFile.xls"

 

[ravishankar]

HI
The following link has a macro.
http://www.mrexcel.com/forum/showthread.php?t=324793&highlight=filecopy
Change filepath suitably and run it
Ravi