Copy files based on the hyperlinkes to a folder

Hi all,

I need help on a project here. I have an excel file that I generated a list of files that I need with all of the file address in column C and I have a macro to make all of those address into hyperlink in column E. These address are the file path in my hard drive and my network drive. For example P:\workfile\general\old emplib\4-27emplib.xlsx and C:\Users\Me\Desktop\worksched.xls

Now here is my problem. I can click on it and save as to a local folder at C drive. but I have like 200+ files that i want to save as to a folder. And I do this like every month, i'm wondering if there is a easier way to do this.

Like VBA code to read all of the hyperlinked file path (or just the file path) and save that file (or copy that file) to a central folder like c:\myfile. I have attached an example.

p.s. Most of them are excel files and TIFF image files.

THank you so much!

No good suggestions??

try to push this thread.....help or at lease give me a pointer.

ok...i guess that there is no other ways. ..