Hi. I am using MS Excel 2007, and I have very basic knowledge on how to use visual basic . I need help with a macro, and I believe this is the best place to ask for help.

I have column "A" a list of my PDF filenames and File path in Column "B". I want to establish hyperlinks for each of these PDF filenames (column A) and link it with the file path that I generated in Column B. =HYPERLINK(B1,A1) did it very well, but unfortunately when converting to PDF, the hyperlink is not working, and I believe the conversion retained is only in text, so now my only resort is by VBA.

Your attention to this matter is very much appreciated.

Thank you very much,
DM