Changing Path of .JPG file?

I

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
 
D

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.
 
I

ironhydroxide

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

Thanks for covering for my stupidity
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code for insert .jpg file 1
update all hyperlinks to another drive 1
insert picture 3
Show Userform when Application Opens 2
Insert picture from filename & path in sheet's cell 1
Inserting Image to the Powerpoint slide using C# from remote jpg f 0
Hyperlink to an image (jpg) opens with IE when the file associationfor jpg is to Picasa 1
Add a Pictures File Name and Path to a cell ? 3

Top