Question: i need short cut how to move files that is included in my excel filename list? is there a faster way or a software that is capable of doing this?\n\ni want to move pictures from a folder containing 34,000 images, but only the ones that are included on my excel file. there are 15,000 filenames on the excel file that i want to move to a different folder. how do i do this fast?\n\nyour help is greatly appreciated!

Answer: You're going to have to create a macro to do this.\n\nIf you know a little VBA, you can figure it out. This web page has most of what you need.\n\nLook at the part that says "Move ALL files (or of a specific file type) from one folder into another folder". You will have to nest a do loop in the code to move each file.\n\nSomething like this (assuming filenames are in column A):\n\nOriginal code:\nfso.MoveFile (sfol & "&#92;*.*"), dfol ' Change "&#92;*.*" to "&#92;*.xls" to move\n\nNested code:\nRange ("A1").Activate\nDo until activecell.value = ""\n   fso.MoveFile (sfol & "&#92;" & activecell.value), dfol\n   activecell.value.offet(1,0). activate\nLoop\n\nI haven't tested the code, so you'll have to do some testing.\n\nHope this helps.
This question from the Yahoo Q&A forum is categorized in the topic: Business & Finance