I found this code for saving a file with its name coming from a cell value within the workbook. Could this be a springboard for a lookup value from a file name based on cell value?
Also, does Excel not recognize a file path as text? I did a combination of the FIND and T functions and the result was always a blank, which means I either formulated it wrong or the path is not recognized as text. If it's not recognized as text, then I'm not sure any formula could be used to change it based on cell value. It would have to be VBA.
Bookmarks