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!
Bookmarks