Renaming photo names 1 - 10 randomizing the images or file numbers.

[0o0o0]

edit:title says 10 photos.. I meant 9 total.

Basically I have a folder... call it PHOTOS

C:PHOTOS>

1.jpg 'tree
2.jpg 'apple
3.jpg 'yadayada
4.jpg
5.jpg
6.jpg
7.jpg
8.jpg
9.jpg

I am looking to randomize these photos by having my vba code run a few extra lines for this ( additional code im seeking here, now)

where it will randomize all 9 photos.. and rewrite new #'s 1 - 9 ... so see where tree is 1.jpg.. it may on random become 7.jpg.. and see apple is 2.jpg that may randomize to be rewritten 1.jpg..

But importantly when finished they all are renamed 1 to 9 jpgs again and without duplicate images.. like 1.jpg (tree) ends up 7.jpg and 9.jpg..

Is this big coding? or fairly simple I have absolutely no idea how to start this.. Ive never worked with rewriting files yet alone randomizing them and making sure they all are still renamed 1 to 9 with out a duplicate imagine written as two jpgs..

Dont want to take up anyones time, I did search the net but ca me up with nothing ... if you know a link that already has this code please let me know.
If youve already done this in any previous projects please paste an example.

Thank you!

[humdingaling]

maybe this can get you started
http://www.excelforum.com/excel-new-...-new-post.html

my contribution is post #16

[Crooza]

Try this

It uses a temp folder in C:photos\photostemp. Just create this folder first and it also assumes that only jpg files are in this folder. I had to add the 5 second delay to make it work.

Please Login or Register  to view this content.

[0o0o0]

omg you rock!

[Crooza]

Glad it worked. Thanks for the reputation points