File copying based on cell value to different directories on some condition

File copying based on cell value to different directories on some condition


Description:
I have lot files to copy into two different directories. I sorted those file names in a such a way that odd row numbered file should go to the directory named "Odd" and even row numbered file should go to the directory named "Even".

I am checking whether the file exists or not in the particular directory before copying. If exists it will ask the user for confirmation and stored with suffix1.

References:
http://msdn.microsoft.com/en-us/library/cahdzfxw%28v=vs.80%29.aspx
http://www.techotopia.com/index.php/Working_with_Directories_in_Visual_Basic
http://www.mvps.org/dmcritchie/excel/strings.htm