Option Explicit
Dim pathname As String
Dim i As Integer
Dim fso As Object
Dim folder1 As Object
Dim file1 As Object
Sub getFileDetailsunderSpecifiedFolder()
pathname = Application.InputBox("Provide path of specified Folder", "Pathname", Type:=2)
i = 2
Set fso = New Scripting.FileSystemObject
Set folder1 = fso.GetFolder(pathname)
For Each file1 In folder1.Files
Cells(i, 1) = file1.Name
Cells(i, 2) = Environ("Username")
Cells(i, 3) = file1.DateLastAccessed
Cells(i, 4) = file1.DateLastModified
i = i + 1
Next
End Sub
https://docs.google.com/file/d/0B23eJ2xd9ODyampNbDRmOEd3R3c/edit?usp=sharing
Dim pathname As String
Dim i As Integer
Dim fso As Object
Dim folder1 As Object
Dim file1 As Object
Sub getFileDetailsunderSpecifiedFolder()
pathname = Application.InputBox("Provide path of specified Folder", "Pathname", Type:=2)
i = 2
Set fso = New Scripting.FileSystemObject
Set folder1 = fso.GetFolder(pathname)
For Each file1 In folder1.Files
Cells(i, 1) = file1.Name
Cells(i, 2) = Environ("Username")
Cells(i, 3) = file1.DateLastAccessed
Cells(i, 4) = file1.DateLastModified
i = i + 1
Next
End Sub
https://docs.google.com/file/d/0B23eJ2xd9ODyampNbDRmOEd3R3c/edit?usp=sharing
No comments:
Post a Comment