Last Modified Date

May 13, 2006

I have a number of excel files in a directory that require me to take action after a file has been saved. What I want to do is create a macro that will look to each file and retrieve its 'modified date', then put that into a spreadsheet. What would be ideal is to create a User Defined Function to look at the last modified date of a file in the cell next to it (I have the files names in a spreadsheet as a hyperlink).

View 2 Replies


VBA Count File Which Modified Date Matches Fixed Date

Jan 9, 2014

I've written a Function which will count the number of files in a folder which the modified date equals a fixed date

For example, here, I want the file count which modified date = 01.01.2014

Function FileCountDate(Path As String, FileType As String) As Long

Dim strTemp As String
Dim lngCount As Long

strTemp = Dir(Path & FileType)
Do While strTemp ""

[Code] ......

However I got a #VALUE! error message with this formula:


In the TEST folder there are 4 pdf files so it should return the value of 4.

View 2 Replies View Related

Get Last Modified Date?

Feb 10, 2012

I have an excel spreadsheet with multiple file names (including file path) listed in a column. I have to update other files using these 'underlying' files. So each cell has the file path and file name (i.e. Q:FolderFile Name.xls). I would like to have the adjacent cells indicate the last modified date for each file. This saves me time from looking for the last modified date manually across different folders in my servers to see if the 'underlying' file has been updated, which I would need in order to update my other files.

So this function would be something like "get last modified date based on file path". I will need step by step instructions as I am not very familiar with VBA.


1 Q:Folder1File name1.xls 2/10/2012
2 X:Folder2File name2.xls 12/1/2011

View 4 Replies View Related

MSG Box - Date Modified

Feb 23, 2010

I am sure this is easy but i cant for the life of me find the code for this:

I am trying to have a MSG Box popup after opening a file and it displays the date the current file was last modified with an "OK" button on it to close the box.

View 9 Replies View Related

Date Last Modified (in Cell)

Jun 10, 2009

I want to know if there is a way to have a cell beside a series of cells that will change its date (and time) when any of the cells in the series is changed.

On a single row, I have four materials that total to a fifth cell. The 6th cell in that row, I would like to have a "date last modified" that would change if any of the first five cell's value is changed.

View 9 Replies View Related

Determine Last Modified Date

Oct 1, 2008

I have a pivot table for which I load data from a .csv file. Is it possible to include a timestamp on when the .csv file was last loaded. If I do it above the actual pivot table, it just shows when the pivot table was refreshed, but not when the .csv file was last loaded.

View 4 Replies View Related

File Date Last Modified From Cell Value

Feb 26, 2013

I have a workbook that column C has computer names starting from C4 to C83. I need to get the Datelastmodified of a log file that robocopy is writting to the following path. \Server1folder1WorkSheetName\%computername%somefile.log. The Datelastmodified needs to be entered in column K for each computer name in column C. One last thing would also be great is if the file does not exist it would write a error value.

View 1 Replies View Related

Add Date Last Modified To Existing VBA Code

Feb 10, 2014

I copied this snippet from the net and it has been working like a charm. I would like to add DateLastModified to it, but I can't get it to work, I'm still kind of new to more complex VBA codes. Here is the code...

Private Sub CommandButton1_Click()

Dim cell As Range
Dim selcell As Range
Dim Value As String
Dim Folder As Variant
Dim a As Long

ReDim Folders(0)

Set cell = Range("B8")

[Code] .........

View 7 Replies View Related

Date Stamp When Cells In Row Are Modified

Sep 11, 2008

I am trying to find a way for an automatic date stamp to be populated into a field in a row when any other cell contained within the same row is changed or modified. I am hoping that there is an easy solution to this. I have tried searching for this and found a few related posts but I don't know how to modify the code to work for me and when I try to do it, it doesn't work. I have attached an example. I would like column B to populate when I modify any field in the row with the date it is being modified.

View 7 Replies View Related

Date Modified Of Text .txt File

Jan 8, 2007

I need to be able to find out which of two .txt files were most recently modified, the two txt files are of fixed name so I can hard code these.

View 2 Replies View Related

List All Files In Directory Modified After Certain Date

Sep 5, 2012

I wish to create a macro that looks in a specific directory "D:Records" . It finds the files which are modified after a date "January 01, 2012" in this directory (pdf files). Then it imports these files names into a worksheet.

View 8 Replies View Related

Excel 2013 :: Date Stamp Modified Row

Apr 3, 2014

Looking to add automatic date stamp to a column of cells each time their corresponding row or specific cell in that row is modified.

I'm using Excel 2013.

View 1 Replies View Related

Open File Depending On Name And Date Modified?

Aug 6, 2014

I have this code, it's working to open the last modified file but how can I implement that it also opens a certain file name.

Test1 150126.xls
Test1 150128.xls
Test1 150140.xls

the numbers are the time the file is saved, is it possible to also look at file name:text1 and then look at the last modified file So only fill in the file name and the macro opens file: Test1 150140

[Code] .....

View 5 Replies View Related

Get The Modified And Open Date Of An External Workbook

Sep 16, 2009

I have a list that show file names and when the necessary works on these files were completed, but the powers that be want more. I have been asked to add two more columns, one showing when the file was last opened and the other when it was last modified.

Is it possible to do this through VBA without having to open the files that are listed? If so I will run the macro when the workbook is first opened.

View 10 Replies View Related

Showing File Last Modified Date In A Cell?

Sep 21, 2009

if there's any sort of script which allows the file's last modified date to be shown in a worksheet?

View 5 Replies View Related

Static Date Insert - Change When Modified

Mar 12, 2008

I have a spreadsheet that has the date in one cell. I want the date to remain static unless I make a change. ie, when I first create the sheet I want a static date to go into this cell. Then I only want this date to change if any changes are made to the workbook (several sheets), I dont want the date to change everytime I open the spreadsheet. It must however update if I make any changes to particular cells on various sheets.

View 9 Replies View Related

Application.FileSearch To Obtain Last Modified Date

Mar 4, 2010

I've been trying to get this to function correctly. The following code does pull out a list of all filepaths, but what I want to to is access the properties of the file.

Basically I select a customer from a combo box, and from this the code does a vlookup to determine what folder the reports are stored in. The list is then entered onto the worksheet 'FilesInReportFolder'. There is some commented out code as I've ben trying to come up with a simple way to remove the 'xls' from the end of the string, but din't worry about that.

I've found a website that suggests adding .name to the lineto get the name instead of the path, but what I really want is be able to pull out other details about the file.

Here's my

Private Sub ComboBox1_Change()

Combobox1value = ComboBox1.Value

Dim rng As Range
Dim RowNo As Integer
Dim NoOfFiles As Integer
Dim foundfilepath As Integer
Dim FilePath As String

View 9 Replies View Related

List Files In Directory With Date Modified

Nov 28, 2006

I currently have a macro working where I can populate the A Column with files from a directory and based on its file extension, however I am having problems trying to populate the second (B) column with that files date modified. I have searched the forum to no avail and I must admit I not the best with vba.

Sub INP_files()
' searches within the file location
' C:Arenium_Projects31-1853012_Barnawartha BOSCADDMX
Dim rngOut As Range
Dim strPath As String
Dim strfile As String
' Sheets("INI_FILES").Select

View 3 Replies View Related

Open Latest File By Date Modified

Feb 29, 2008

I have manged to search for the last updated file on a folder but i want to use the filename as the source for a copy and paste. it all seems to work bar the linking of the 2 processes the error message 'run time error 9 subscript out of range' is the file is already open should it just not use the same variable to copy the files?

Option Explicit

Sub Get_Availability_Data()

Application. ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False

Dim wsTo As Worksheet, wsFrom As Worksheet

Dim myDir As String, fn As String, a(), n As Long, myFile As String
Dim myDate As Date, temp As Date
myDir = "C:BarkingEMCIN"
fn = Dir(myDir & "*.csv")
Do While fn <> ""
temp = CreateObject("Scripting.FileSystemObject").GetFile(myDir & "" & ................................................

View 9 Replies View Related

Displaying Last Modified Date And Time Of File In A Cell

Jul 11, 2009

How can display the last modified date and time of my excel file in a particular cell - Say in cell E1.

This is the same value that we get when we Right Click excel file->Properties->General and look at the label "Modified".

View 8 Replies View Related

Adding Date Modified To PDF File Extracting Macro

Jul 3, 2014

Below Macro which I am using to extract .PDF files. Now, I also want to see the Date moified while extracting the .PDF files. Hence, adding date modified to this macro.

Sub get_pdf_name()
Dim FR As Long, sh As String, FPath As String, FName As String
sh = Sheets("Sheet2").Name
FR = Sheets(sh).Range("A" & Rows.Count).End(xlUp).Row + 1

[Code] .....

View 1 Replies View Related

VBA - Generate Date Range Within 2 Supplied Dates (Modified)

May 11, 2009

I just wanted to understand something about some code that was supplied to me on this forum. The code works perfectly, with the exception of one minor issue. The original thread and solution presented is found here

View 2 Replies View Related

Excel 2010 :: Function For Last Modified Date Of Cell?

Feb 14, 2012

What I wanted was to a function, say, "=LastModifiedDateOf(CELL)", where CELL, is a parameter that indicates the cell I want to monitor. If the value of such cell ever gets changed, the cell containing the function has its value updated to the current date.

A1 = "AA"
A2 = "=LastModifiedDateOf(A1)" -> "10/03/2011 10:30:32"

-- Make an update:

A1 = "BB"
A2 = "=LastModifiedDateOf(A1)" -> "14/02/2012 12:15:11"

I'm not quite a super user in Excel, but this function would be very very useful for me.

ps. I'm using Office 2010

View 4 Replies View Related

Excel 2007 :: Adding Date Last Modified In A Cell Using VBA?

Jul 10, 2012

I need to insert a date modified column to an Excel 2007 workbook I am currently using. The columns range is from A to L, with about a hundred data points. However, I would like to have the date modified cell update only when there are changes to rows F through L, starting with row 3.

I need the code to still function if I add rows, and it would be great if it would also still run if I added columns, but that part is not necessary. I've gotten close by defining a cell name as myCol and using this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Row < 3 Then Exit Sub


View 4 Replies View Related

Excel 2007 :: Sort All XLS Files In Folder By Modified Date?

Jul 24, 2012

I'm trying to sort all .xls files in a folder by modified date. I want most recent at top because then I will be cycling through and using the most recent version of files that have similar names.

Excel 2007.

The code I have so far is this:

Sub autolink()
Dim folderPath As String
Dim FileName As String
Dim wb As Workbook


But I need something before it sort the folder by the modified (or better creation date) because there are several files with similar names. I know know, I could put a date in the file name and look for that but I don't control the naming of the files.

View 7 Replies View Related

Modify/Edit File Properties (Date Modified) Of Workbook

Apr 8, 2008

I want to amend the ' Date Modified' for a spreadsheet. I have just made changes to it - so the 'Date Modified' shows today's date and time. Is there a way of changing the 'Date Modified' so it shows as yesterday's date?

View 3 Replies View Related

Code To Update Cell With Current Date And Time When Other Cells Are Modified

Mar 11, 2014

I needed a code that would input the current date and time in the cells in column N whenever changes were made to any cells in the row from columns A to M. For example, if I change a name in cell 6D, then cell 6N would automatically change to the current date and time.

I found a useful code on a forum (maybe here, don't know for certain) and modified it to suit my needs (see below). I am however now getting a debugging error suggesting that the second line that reads "Private Sub Worksheet_Calculate()" is causing an error.

View 11 Replies View Related

Search Folders & Subfolders For Files By Date Modified & Move/Copy Them

Aug 5, 2009

I'm trying to make a macro that will search a folder and move all files from 2008 into another folder. So far it can do this, but what i need is for it to search subfolders also. At this point it moves all files from the main folder, but nothing from the subfolders.

Option Explicit
' Reference site [url]

Sub Copy_and_Rename_To_New_Folder()

Dim objFSO As FileSystemObject
Dim objFolder As Folder
Dim PathExists As Boolean
Dim objFile As File
Dim SrcFolder As String
Dim DestFolder As String
Dim x, Counter As Integer, Overwrite As String, strNewFileName As String
Dim strName As String, strMid As String, strExt As String
Dim LastModYear

View 5 Replies View Related

Modified By According To Each Cell

Jan 12, 2012

I wonder if is posible to discover following:

Who modified the cell from various users.

After that how many cells from xls fiile were modified by one user and how many by another user.

View 1 Replies View Related

Can This Code Be Modified To Run Faster

May 30, 2009

way to bring more efficiency in this code.

I need to run this code on 100,000 rows every week and this takes hours to finish.

View 14 Replies View Related

Copyrights 2005-15, All rights reserved