move files to another folder delete original

[D_Rennie]

hello.

i would like to be able to move files from one folder to another then delete the original files.
I dont think im passsing the variables to the functions corectly.
been trying this for a while now and cant get it.

Please Login or Register  to view this content.

and help would greatly be appresated.

cheers

[royUK]

Check this page

http://www.rondebruin.nl/folder.htm

[D_Rennie]

im still strugling. im thinking from the examples on the link, they are not to diffrent to what im trying.

though becouse im using application.getopenfilename to select mutipul files. I figured that the files needed to be stored in a array and then loop through to deal with each seperate file. and this is where im lost the file name will change for however many times for the files in the array. from that im trying to extract the file name and file extention to be used for the new location naming.

hope that makes sence.

[pike]

Hey D_Rennie

Please Login or Register  to view this content.

Please Login or Register  to view this content.

does this help?

[D_Rennie]

hay pike how you going???

It helped me to understand it better.

i now got the filename and extention extracted fine though its the array that is stuffing me up

Please Login or Register  to view this content.

even this error out

im about to scrap this idear and just use a groupe of cells for each complete filepath and extracted filepath.

the reason that have tryed to get this to work so long is i aready had the array from attaching the files to a email so though the move wouldnt be to hard.

Thankyou for the help.

[pike]

Hey D_Rennie

any thing can be done

what do you need
1 select File
and 2 move it

[pike]

Dude
from Julitta Korol

Please Login or Register  to view this content.

[D_Rennie]

Hay pike.

Cheers for the code. I will use most of that for what im doing, It has some great error handling. What i was trying to do was use the getopenfile in an array.

so where it has

Please Login or Register  to view this content.

The programing needed to get it working has getting the better or me.

So the answer for this one is going to be what is a probley better way anyhow. This way i can store all the file information on a spreadsheat and use some of this within the email sendout.

I will loop through the array and store the original file path in column A"aready tryed this and works fine. Also pull the file name+Ext and file size for column B & C. Then use the code you gave me to loop through the files from column A to transpher to a newley created folder. Kill the original files. Then use the thansphered files for attaching to a email"also done this works fine"

So going this way it is quite simple and would have been done long ago. Though im like a fly in a horse padic when im trying somethink new, Cant get me off the ++++ until i figure it out, or the ++++ sumthers me.

Ill mark solved, Though post back the code that i will run with.

Cheers for all the help, Many thanks.

[D_Rennie]

Here is what i am going to run with, Just incase you where intrested.
Cells D1-E1 must cointain text, and must not contain illegal charters /-? ect
Note this will delete the original file after it is placed into the new folder.

Please Login or Register  to view this content.