Copy images from one folder to another

NoSparks · #5 07-02-2015, 07:37 AM

It's simpler than that, this was the part of the linked to page meant for you to see

Code:

Dim SourceFile, DestinationFile As String
SourceFile = "SRCFILE"   ' Define source file name.
DestinationFile = "DESTFILE"   ' Define target file name.
FileCopy(SourceFile, DestinationFile)   ' Copy source to target.

your SourceFile would be your A cell & "\" & your B cell
your DestinationFile would be your C cell & "\" & your B cell

you need the above inside a For-Each-Next loop of the data rows of your sheet.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy from web and paste in a word document : no images are shown	Ron Wolpa	Word	5	09-11-2013 02:16 AM
Copy formatting setting between images on the slide	pogonoforysci1	PowerPoint	11	08-10-2012 03:54 AM
Loop through folder of workbooks and copy range to other workbook	Snvlsfoal	Excel Programming	3	07-29-2011 05:55 AM
copy-pasting hyperlinked images: work only at the edges	Xuanzang	PowerPoint	0	12-07-2010 02:35 AM
Copy email to another folder	loc	Outlook	0	12-26-2006 07:39 AM