Changing Path of .JPG file?

[ironhydroxide]

I was wondering if it was possible to change the path of a .JPG file using an
excel Macro.
I have a database of people, and when they leave, I also have a folder with
everyones .JPG Picture (which i use to make a printoff of the people here and
their pictures) I was wondering if one could Program in a SubFunction to,
when the leave date has passed, move that certain .JPG file to annother
Directory/Path in that same drive.

Thank you

Ironhydroxide

 

[Patrick Molloy]

you can use the FileCopy with a delete (Kill statement)

 

[Dave Peterson]

Personally, I wouldn't use excel for this kind of thing.

I'd just open Windows explorer and drag the .jpg file from one folder to another
(or Cut, then paste).

But if you want to use an excel macro, search VBA's help for "Name statement".

There's an example there, too.

 

[ironhydroxide]

Searching could have probably helped me (in the Help section)

Thanks for covering for my stupidity

 

[Don Guillett]

Look in the vba help index for NAME