I have a list of filenames (complete with file extensions) in a single column
in an Excel Worksheet. All of these listed files are in the same folder
(along with many other files) on the hard drive. Each filename in the list
is hyperlinked to the actual filespec (drive, folder, filename). The list
may contain several hundred filenames. How do I read the list of filenames,
find the actual files, and copy them all at once into a separate folder on
the hard drive? I can manually search with Win Explorer and select each file
using Ctrl-Click & mass copy using Paste, but its very laborious. Is there a
commercial software product to accomplish this job? I'm using Win Vista Home
Premium & Excel 2007. Also have XP Pro & Excel 2003 available.