Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open all files in directory | Excel Discussion (Misc queries) | |||
List of Files in A Directory | Excel Discussion (Misc queries) | |||
Files in a directory? | Excel Discussion (Misc queries) | |||
Open all files in a directory | Excel Programming | |||
Copy range of many files in directory. | Excel Programming |