Moving files based on the value of a cell?

[shannonmarie111]

Hi everyone. I'm really new to this kind of stuff but mu boss has asked me to come up with something. I have a spreadsheet with file names in column A and either a "Y" or a "N" in column B. All the files that correspond to he file names are in folder "C:\copyfrom". If the value in column B is "Y", I need to either copy or move (they don't really care which) that file to "C:\moveto". I have been looking at code I see online forever,trying to manipulate it so this works and am having zero luck. Can anyone help me? Thank you!!

 

[shannonmarie111]

1. Can you post what your data in column A looks like?
2. Are your "y's" in column B in lower ot upper case?

To easily get the it right, please post sample data

Here is what I have:

00~BERKS~000000~Target Condo~Other~Other n
01~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
02~BERKS~000000~Target Condo~MISC~Miscellaneous Documents n
03~BERKS~000000~Target Condo~MISC~Miscellaneous Documents n
04~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
05~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
06~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
07~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
08~BERKS~000000~Target Condo~MISC~Miscellaneous Documents n
09~BERKS~000000~Target Condo~MISC~Miscellaneous Documents y
10~BERKS~000000~Target Condo~MISC~Miscellaneous Documents n

 

[shannonmarie111]

https://drive.google.com/file/d/0B1_RMmJIeGojUktqbVVDRW51U3c/view?usp=sharing

Here is a screenshot

 

[Momentman]

If i were to take a guess, it might be because your filenames don't have extensions at the end.

Like the code recognises "koala.jpg" but not "koala". But then again, if it can't locate the file, the code should error out and not just run and do nothing

Are all your files of same extension? and what type of files are they actually

 

[shannonmarie111]

If i were to take a guess, it might be because your filenames don't have extensions at the end.

Like the code recognises "koala.jpg" but not "koala". But then again, if it can't locate the file, the code should error out and not just run and do nothing

Are all your files of same extension? and what type of files are they actually

They are all PDF files. I can add the pdf extension on to the file names in the spreadsheet and then run it again.

 

[shannonmarie111]

They are all PDF files. I can add the pdf extension on to the file names in the spreadsheet and then run it again.

I added the ".pdf" to my spreadsheet and still no luck

 

[shannonmarie111]

Wait, I think it worked, please hold!

 

[Momentman]

Wait, I think it worked, please hold!

No problems at all, waiting for your feedback

 

[shannonmarie111]

No problems at all, waiting for your feedback

It moved 3 files (I have about 500) and I can't get it to do it again, it keeps saying file not found

 

[Momentman]

There's no reason why it would copy files selectively. If it moved/copied some, then the code does work

Can you confirm that the files it fails on actually exist?

 

[shannonmarie111]

There's no reason why it would copy files selectively. If it moved/copied some, then the code does work

Can you confirm that the files it fails on actually exist?

I had a couple typos, I feel so silly thank you SO much!!!!