Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Copy Files Listed in Excel Worksheet ?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove listed shortcuts for deleted Excel files? | Excel Discussion (Misc queries) | |||
How to exctract files listed in an Excel-file from a folder? | Excel Discussion (Misc queries) | |||
increase number of files listed In the drop down box on my compute | Excel Discussion (Misc queries) | |||
Copy Excel data content listed in 3 columns into a single column | Excel Programming | |||
why can't excel do a simple find and copy row from a worksheet to. | Excel Worksheet Functions |