Hello
I want to compare between 2 files by the date they were created and separate the month from the created date.
Thank you
Hello
I want to compare between 2 files by the date they were created and separate the month from the created date.
Thank you
[VBA]
Sub ShowFileInfo()
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("C:\AAA\Example.xls")
s = "Created: " & Format(f.DateCreated, "MMMM")
MsgBox s
End Sub
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'