public functions

In my last post about how to append or prepend text to data in a cell, Larry asked how one might be able to display the modified date of an excel file. This tutorial will explain the most efficient way to display the modified date of the file you are working on in a cell. Get Ready For Macros Getting right to it, the modified date of an excel file exists, but it isn't accessible via any of the functions that Excel has created for us. Instead, we'll create our own function in the Visual Basic … [Read more...] about Display Modified Date of Excel File