Amazon Great Offers

February 11, 2011

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
Post a Comment

Featured Post

Java Introdcution

Please send your review and feedback to psrdotcom@gmail.com