Macro to Import from Hyperlink

[aa2000]

Hi all, again

I am still working on this rather massive excel tool hence the questions which I hope you guys do not find irritating or stupid.

The macro currently creates hyperlinks in cells, but the text displayed is only the file name, not the full file path.
Now I am trying to write another macro that will use the full file path to import the data from the text file that the hyperlink leads to.

What code can I write to get the macro to read the filepath of the hyperlink rather than just the displayed text?

Thanks again guys!