binar
07-13-2015, 07:33 PM
Fellow Forum Members,
I would be very grateful if someone can help me in developing a VBA that automatically generates a hyperlink list that auto matches. Let me elaborate. I have 400 PDF in this directory:
C:/art/schematic01.pdf
C:/art/schematic02.pdf
C:/art/schematic03.pdf (plus 397 more PDF file names)
In addition, in "Column A" of my Excel file I have a list of 55 PDF files I need hyperlinked to only 55 (out of 400) PDF files located in my "C:/art" folder. My "Column A" Excel list looks like this:
A
1 schematic 13.pdf
2 schematic 45.pdf
3 schematic 30.pdf (plus 52 rows of more PDF file names)
However, what I want to avoid is having to manually match 55 file names for creating 55 hyperlinks to the PDF files located in my "C:/art" folder. Is it possible for a VBA to automatically create the 55 hyperlinks for me that automatically does the matching for me between my list in "Column A" and 55 out of 400 PDF files located in my C:/art folder? Any help in developing such a VBA will be greatly appreciated. Thanks in advance.
I would be very grateful if someone can help me in developing a VBA that automatically generates a hyperlink list that auto matches. Let me elaborate. I have 400 PDF in this directory:
C:/art/schematic01.pdf
C:/art/schematic02.pdf
C:/art/schematic03.pdf (plus 397 more PDF file names)
In addition, in "Column A" of my Excel file I have a list of 55 PDF files I need hyperlinked to only 55 (out of 400) PDF files located in my "C:/art" folder. My "Column A" Excel list looks like this:
A
1 schematic 13.pdf
2 schematic 45.pdf
3 schematic 30.pdf (plus 52 rows of more PDF file names)
However, what I want to avoid is having to manually match 55 file names for creating 55 hyperlinks to the PDF files located in my "C:/art" folder. Is it possible for a VBA to automatically create the 55 hyperlinks for me that automatically does the matching for me between my list in "Column A" and 55 out of 400 PDF files located in my C:/art folder? Any help in developing such a VBA will be greatly appreciated. Thanks in advance.