Need to open links to PDFs and save them to a folder

[msdelaney]

Hi,
I've been given a task of opening a list of hyperlinks from an excel file in Column H and save them to a new folder. All the hyperlinks are links to pdf files on our network drives. Right now I am clicking the link to the pdf, I save as and save them to a new folder "O:\Individuals\Niel\North Kona", and this is for hundreds of links. I was just wondering if anyone could help me with a macro that can do this for me.
Thank you

[kev_]

Try this:
(avoids requirement to open the pdfs)

VBA1 creates (in sheet "FileList") a list of links and pdf file names
VBA2 saves those files to your folder

What you need to do (in a copy of your file!!)
- paste both VBA1 and VBA2 into a general module
- add a new sheet and name it "FileList"
- go to the sheet containing links in column H
- run VBA1 from that sheet
- look at output in sheet "FileList"
- if happy, then run VBA2
- check contents of folder

VBA1

Please Login or Register  to view this content.

VBA2

Please Login or Register  to view this content.

FileList.jpg

[msdelaney]

Its works perfectly. Thank you soooo much. It helps me out alot.

[kev_]

You are welcome.