Hi,

I have thousands of files in a folder and I want to extract the part of filename and create their hyperlinks. My files in a folder (VCD) look like this:
US45102950_25165521_Feb07_1.jpg
US45102950_25165521_Feb07_1.pdf
US45102950_25165521_Feb07_1.txt
US45102950_25165521_Feb07_1.tif
US45102950_25165521_Feb07_2.jpg
US45102950_25165521_Feb07_2.pdf
US45102950_25165521_Feb07_2.txt
US45102950_25165521_Feb07_2.tif

My excel file in different columns(A, B, C, D, E, F, G, H) should look like
A B C D E F G H
US45102950 25165521 Feb07 1 jpg pdf txt tif
US45102950 25165521 Feb07 2 jpg pdf txt tif

When I will click on any of jpg , pdf ot txt link, it should open its respective file. Actually each file has four different extenstions like jpg, pdf, txt, and tif but the filename is same. I want to extract the information of filename after each "_" in different column and with their hyperlinks of jpg, pdf, txt, tif files in a single row. So that will have information of four files in a single row. That will really help me in managing my files and viewing those files.

I have just started learning VBA programming. Please help me in making the code.

Thanks in advance

Manish