" wrote:

you could have your VBA macro read the rows in the Excel sheet one at
a time.
For each file name use the InStrRev function to find the base name of
the file (ie to strip of the drive and folder part of the file name)
then use the FileCopy statement to copy the file from its original
location to the target folder .

Catherine


Hi Catherine ...
Thanks for your suggestion ... will give it a go. I can easily delete the
hyperlinks & end up with a list of base filenames (with Extensions, but
stripped of Drive and Folder) in a single column in the worksheet. I'm an
amateur with VBA, but can Do Loop thru the list & use the FileCopy Statement
on each row (cell) in the list. Not sure how to program substitution of the
filename (in each cell of the worksheet) into SourceFile and DestinationFile
in the FileCopy Statement. Will pursue it ... thanks again for your help!