find files and copy to new directory
 

In col F I have the full path for several picturefiles like
I:\300\300531-Nicopan.tif. I want Excel to "find" (i know they are ther)
these files and copy them to my directory d:\logofiles. Is It possible?

Thanks..

Arne

find files and copy to new directory
 

Hi Arne,

See help for filecopy in VBA.

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

find files and copy to new directory
 

FileCopy source, destination

ie. Sourec = c:\dir1\dir2\picture1.jpg
Destination = c:\dir1\dir3\picture1.jpg

If the picture files are open, the above fails.

Lars Kofod
-----Original Message-----
In col F I have the full path for several picturefiles
like
I:\300\300531-Nicopan.tif. I want Excel to "find" (i
know they are ther)
these files and copy them to my directory d:\logofiles.
Is It possible?

Thanks..

Arne



.

find files and copy to new directory
 

I was not exact.. The file paths where the pictires are, are different,
and I do not know how to loop every single
cell i column f - copy the file to the new directory, then go to the next
cell in col f and do
the samething, and stopp when last cell has nothing..

wrote in message ...
In col F I have the full path for several picturefiles like
I:\300\300531-Nicopan.tif. I want Excel to "find" (i know they are ther)
these files and copy them to my directory d:\logofiles. Is It possible?