Changing Path of .JPG file?
 

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

Changing Path of .JPG file?
 

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

"ironhydroxide" wrote in message
...
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

Changing Path of .JPG file?
 

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

Changing Path of .JPG file?
 

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" wrote in message
...
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

Changing Path of .JPG file?
 

Look in the vba help index for NAME

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ironhydroxide" wrote in message
...
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