Copy hyperlink content to folder and add prefix name to the files

**mikephie** · 01-11-2020, 12:07 AM

Hi Expert

I need your help, from screenshot below Column A is the Prefix No and Column B is the file name ( hyperlink ),
Can i have a vba script to download all the hyperlink contents to a folder and add a prefix id ( from Column A ) to the file name accordingly.
Thanks.
Screenshot 2020-01-11 at 12.01.46 PM.png

**davesexcel** · 01-11-2020, 05:27 AM

Hello,
Where are these files located?

**mikephie** · 01-11-2020, 06:45 AM

Hi

All files was located in C drive.
C:\Uniqlo

**davesexcel** · 01-11-2020, 07:01 AM

Not sure what you are asking, you say,
"download all the hyperlink contents to a folder and add a prefix id ( from Column A ) to the file name accordingly."

Did you want to copy those files into a new folder and rename them?

**mikephie** · 01-11-2020, 07:20 AM

Yes, exactly .
Copy all files to a new folder and add a prefix id infront of the actual name.

**mikephie** · 01-11-2020, 07:23 AM

Example like 02_20ss........... To C:\Temp

**davesexcel** · 01-11-2020, 08:16 AM

First we need to extract the folder name from the hyperlink, then rename it and copy it to the destination folder with the new name

Change destination folder in the code to your folder name

Please Login or Register  to view this content.

**mikephie** · 01-11-2020, 10:33 AM

Thanks for great your help, i'll try and let you know.

**mikephie** · 01-12-2020, 10:58 PM

Hi davesexcel,

Awesome.Your script its working.
Can you do me a favour again.
Base on the store name, collect all the files into individual folder ( store name ) with the quantity given ( copy multiplies of the file )
Please remain last setting.
Attached pix for your reference.
Attachment 657487

**mikephie** · 01-12-2020, 11:17 PM

Hi davesexcel,

One more thing, does vba working on MAC platform?
Why must create new workbook to run the VBA script?
If not the script just run once and not working anymore.