I am wondering if the following is possible.
I have an Excel worksheet which has various columns. One is a column that has ID numbers in. Each ID number relates to a .txt file called the same as the ID number(which are located in the same folder). In the column next to this i want to place a hyperlink that references the .txt file matching the ID number. I have a lot of ID numbers so manually doing this is going to take forever and its also an on going project.
Has anyone got any suggestions using VB? i know VERY little about it but i can get by using examples.
Any help is appreciated.