Dear all,

I have a spreadsheet with the following data:

Column A B C D
E:\HALCONtemp\ASP12.2\ -13438 -50576 8030
E:\HALCONtemp\ASP12.2\ -13445 -48132 8940
E:\HALCONtemp\ASP12.2\ -13451 -51858 7830
....

I am a somewhat newbie and am trying to generate a macro that will
enable me to hyperlink each Row in Column A and open the associated file.

So, in the example above, the folder 'E:\HALCONtemp\ASP12.2\' has the
file '-13438_-50576_8030.tif' that I would like to open (as a preview).

So, to generalise, Column A has the folder 'An' and I would like to open
the file 'Bn'_'Cn'_'Dn'.tif associated with it.

Hopefully that makes some sense. Any help would be greatly appreciated.

Andy