Not sure if this is the right place to ask this, but.....
Is there a way to cut and paste (into excell - preferably) the information inside a folder? For example, when you drill down into a folder to view its contents - name, size, date modified etc.
I need to be able to cut and paste all that information, from different folders, so I can keep track of overal progress on a project. I can cut and paste the name, but that brings with it the actual file - which I don't want. Print screen doesn't work either. And I really need the date modified information. So far, I can't find any way to copy that info.
Any help would be greatly appreciated.
Thanks.
Hi runnymede15june1215
the folder infomation attributes can be access like files eg...
Sub InfFolder() Dim fs, strFolder As String, objFolder, colFiles strFolder = InputBox("Enter the folder full name:") Set fs = CreateObject("Scripting.FileSystemObject") Set objFolder = fs.GetFolder(strFolder) Set colFiles = objFolder.Files ' files in in folder is a collection MsgBox "files in the folder:= " & colFiles.Count & chr(10) & _ " Path:= " & objFolder.Path & chr(10) & _ " size:= " & objFolder.Size & chr(10) & _ " Parent Folder:= " & objFolder.ParentFolder & chr(10) & _ " attributes:= " & objFolder.Attributes & chr(10) & _ " date created:= " & objFolder.DateCreated & chr(10) & _ "drive:= " & objFolder.Drive & chr(10) & _ "type:= " & objFolder.Type End Sub
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks