Help Requested in Creating Hyperlink VBA

[DesertMoon20]

I posted this originally in the Excel General, but I believe it should be posted here...


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

[Chippy]

You shouldn't need VBA for this. With, for example MyFile.pdf in A1, C:\folder\path\ in B1 (note the trailing \), the following formula in C1 should work:

=HYPERLINK(B1&A1,A1)

If the file paths don't include the trailing \, use:

=HYPERLINK(B1&"\"&A1,A1)

[DesertMoon20]

Thank you Chippy,

I have stated in this thread that I have used that function but when converting to PDF that hyperlink is not working as it was converted to text. I need the actual hyperlink to work, that is why I am asking for help to VBA this instead.