I have an excel database with information that is related to pictures I have in a folder on my computer. They are related by the file path of the picture but soon the database and picture folder will move to a different computer. Is there a way to write a VBA function to look for a given file name on a computer and return its file path (basically update the file path after the file has been moved).
Bookmarks