Not sure if this can be done. There are word files in a directory with all familiar names. i.e. fr001, fr002, fr003, etc... all with the extension .doc. I would like to know is there a code that will link an excel file to a directory and then be able to type the file name within a cell and it is automatically hyperlinked to that cell?