Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the path behind a button | Excel Discussion (Misc queries) | |||
Changing path for import file | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
Changing Query path | Excel Programming | |||
Changing the Path In a Usage Log | Excel Programming |