Vba file attributes list

Name , -1 ,vblf ,"Type: " ,"" ,7. Name , -1 ,vblf 4. Name , -1 ,vblf 3. ReadAll, vbCrLf 5 , 14, ReadAll, vbCrLf 6. Open ThisWorkbook. BuiltinDocumentProperties BuiltinDocumentProperties "number of bytes". Name , 1. Name , -1 ,vblf 7. Name , -1 ,vblf ,"Size: " ,"" , Name , -1 ,vblf 2. Name , 6. BuiltinDocumentProperties "creation date". Name , 4. Name , Name , 5. ReadAll, vbCrLf 5 , 19, Name , -1 ,vblf ,"Last modified " ,"" , BuiltinDocumentProperties "last save time". Name , 3. BuiltinDocumentProperties "last printdate".

FullName "". FileExists ThisWorkbook. Name , 7. Name , 8. BuiltinDocumentProperties 1. BuiltinDocumentProperties "Title". BuiltinDocumentProperties 2. BuiltinDocumentProperties "Subject". BuiltinDocumentProperties 3. BuiltinDocumentProperties "Author".

Name , 9. Name , -1 ,vblf 1. Name , -1 ,vblf ,"Auteur: " ,"" ,9. BuiltinDocumentProperties 4. BuiltinDocumentProperties "Keywords". BuiltinDocumentProperties 5. BuiltinDocumentProperties "Comments". BuiltinDocumentProperties 6. BuiltinDocumentProperties "Template". BuiltinDocumentProperties 7. BuiltinDocumentProperties "Last Author". BuiltinDocumentProperties 8. Active 1 year, 7 months ago. Viewed k times. The goal is to create a detailed list of all the files on a file server.

Todd Main Add a comment. Active Oldest Votes. You say loop.. Items Debug. Print oDir. GetDetailsOf oDir. Item "FILE. June7 Alex K. Also See Microsoft site: technet. For those directed here this is out of date a bit. There are now attributes you can use. For example, file version Update the for loop to see them all. Further update: As of sometime this past summer all indices above 6 are invalid, returning only empty strings. Print Class1. GiveMeATwo In some ways, this simulates the behavior of static classes in other languages, but unlike other languages, you can still create an instance of the class.

Print cls. It cannot be accessed outside of the current project. Print myList. Count Then. Remove index. Previous Next. Remember, the people on these forums are generally giving their time for free. Use Excel Rescue , who are my consultancy partner. They help by providing solutions to smaller Excel problems. Rename columns in Power Query when names change. Clear old items from a PivotTable filter list. Why are Excel formulas not calculating? VBA to sort sheets alphabetically. Office Scripts — Sort sheets alphabetically.

Use Office Scripts with Power Automate. Office Scripts — Hide all sheets except one. September 20, at am. Regards, Henriette Reply. September 22, at am. September 22, at pm.