If I have in Cell A1 the root directory (i.e. C:\My documents\March) and b1 has the file name (Worksheet1.xls), is there a way to put in b2, for the formula to look into the root directory, search for the file name, and return when the date the file was created? And in b3, when it was modified if at all? And if the file is not available, to return the text value of "File Not Available"?
Please note that the month will change often. Is this possible?
Please note that the month will change often. Is this possible?