last modified date

Hello, I'm trying to figure out a way to get a cells "last modified date" in order to use it with XLOOKUP. I've seen examples where people are using formulas to CREATE a TIMESTAMP in a separate column, but I can't use those examples as written considering I have actual dates in the column that...

I have the following code which, when called, will display the folder contents as a list on a dashboard in Excel: Sub DisplayInProgressBeth() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Range("S29:S38").Select Selection.ClearContents 'Create an...

Hi, Been scratching my head at this all day, fairly new at understanding code for excel as well. I have a sheet I use for production , a little conditional formatting for a simple RAD (red amber green) status using 1 2 3 in each cell (see attached imgur pic) https://imgur.com/5a95wjS What...

Hello, I am wondering if there is a simple Excel Worksheet Function (or less ideally, a custom VBA-defined Function) which can automatically return the date last modified, i.e., when the document was last updated/modified, recalculated and/or saved? Thanks for any tips. K.

Hi everyone - I found this great code below that extracts the file names for all files in my folder. I was wondering if anyone knows how to also add the: "file path"; "file size"; "last modified date"; and "last modified by". Please let me know if you have any thoughts! Sub Auto_Open()...

Hi, I have a table and a field called Last Modified Date. I want somehow to automatically update the if value changes in that row. Example ID Fruits Last Modified Date 1 Apple 17/10/2010 2 Apple 17/10/2010 3...

Hello all. I use the code below to record the time a cell value changes. This works good so long as the cell was changed by direct input. I have a case where it would valuable to be able to automatically record the time/date a cell was modified for cells that are changing, but changing only by...

VBA Newbie here. Please forgive any protocall mistakes: I currently use the following to test for files to exist after running a batch to copy them from various locations on a network. Works well allows wildcards in path, file name and extension. Private Function IsFileTrue(fDriveFolder...