Hyperlinked documents to PDF

[vbahelpneededplease]

I have a workbook that has a list of hyperlinks to documents on a drive. I have a toggle check box next to each one item on the list. I would like to create a macro that will generate a pdf from all of the linked documents which are selected. That is to say, I'd like to be able to check the boxes next to some number of hyperlinks, click a button, and have a pdf of all of the selected ones created. The documents currently exist as word docs. Any help in this matter would be greatly appreciated.

[kev_]

Hi
Welcome to the forum

Please test in attached file first by doing the following:
In Excel:
- replace my links with links of your own in column A
- do this by right-click the cell and replacing the link (as per picture below)
- select a cell in column B to automatically add/remove a tick against each link
- see *note2 below
In VBA:
- amend the folder path to save pdf files by amending this line - ensure you add the trailing "\"

Please Login or Register  to view this content.

- for the first test everything goes in that folder (see *note1)
- go back into Excel
- run the VBA with {ALT} t

*note1
if you want the pdf's to go to more than one folder, then VBA requires amendment
- let me know the rule
- perhaps same folder as the original Word file?
- or possibly a folder path determined by original Word file?
etc

*note2
you did not explain how your links were created and
- this code may need to be adapted slightly to work with your links
- are your links simple links created as above?
- if not, let me know method/formula etc


EditLink.jpg

In module1:

Please Login or Register  to view this content.

Please Login or Register  to view this content.