Create a Hyperlink Macro

Can this be done? This is what I want to do. Say I have a workbook open and my A column cells are filled with (example) Mike-1 in the first row Mike-2 in the second row and so on. Now I have another folder on the computer with Word documents that I want to hyperlink to. The corresponding Word file is named mike1. So I want Excel to go through column A and Hyperlink to the corresponding Word file. Is it possible to do this?

This code cycles through the selected range and creates file links base on the cell contents by:
• Removing the dashes in the cell value
• Prepending a file path
• Appending a file type
• Creating the link from the result
Note: The display text is not change.

Please Login or Register  to view this content.

Is that something you can work with?

Originally Posted by BostonMike

Woah, cool. I see your notes in the code on where to replace with my data but I'm such an Excel neophyte I don't know where to place the code.

• ALT+F11.....to open the VBA editor
• Right-click on your workbook's name in the Project list....Select: Insert Module
• Copy the vba code I posted
• Paste it into that module

To use the code
• Select the range of cells to be impacted
• ALT+F8....To open the macro list
• Select: ConvertCellTxt2FileLink
• Click: Run

Does that help?

Thanks for the kind words....I'm glad I could help.

Regarding learning Excel VBA:
There are many books with various teaching approaches.
Choose one that suits your learning style.

THEN..(and this is important)
Apply what you just learned in an aggressive project, not a little one-off project.

Why?...Because an aggressive project will punish you mercilessly for any inefficiencies
in structure or methodology. Thereby, ensuring that you don't develop any bad habits
whose impact would be masked by a small project.