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

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

"ironhydroxide" <(E-Mail Removed)> wrote in message
news:02E2CDC5-19DE-49EB-A6EB-(E-Mail Removed)...
> 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

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 wrote:
>
> 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

--

Dave Peterson

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

Thanks for covering for my stupidity

"Patrick Molloy" wrote:

> you can use the FileCopy with a delete (Kill statement)
>
> "ironhydroxide" <(E-Mail Removed)> wrote in message
> news:02E2CDC5-19DE-49EB-A6EB-(E-Mail Removed)...
> > 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
>
>

Look in the vba help index for NAME

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"ironhydroxide" <(E-Mail Removed)> wrote in message
news:02E2CDC5-19DE-49EB-A6EB-(E-Mail Removed)...
>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