![]() Title of audio/video files (mp3, ogg, mpeg, mp4 and many more, see below). Title of document files (PDF, HTML, MS-Office, Open-Office etc.). Volume name and free space of the current drive.Ĭalculated checksums for files: CRC32, MD5, SHA1, SHA256, SHA512.įile access rights for current user (or administrator if the program was started with administrator rights). Display of the file type confirmed by the signature, alternatively suspected file types.ĭisplay of confirmed and suspected file types in plain text.įle attributes (Archive, Read Only, Hidden, System, Compressed, Encrypted, Temporary, Sparse File, Reparse Point / Symbolic Link, Offline, Not Indexed).įile availability (always, local, online). Verification of the file type based on the file signature of the content. Display of ADDITIONAL FILE INFORMATION:įile size with automatic range selection (Bytes, KiB, MiB, GiB).įile size effectively on disk (Bytes, KiB).Adjust the column specifications yourself: column title, maximum column width, fixed column width with word-wrapping for output in Microsoft Office Excel™ and OpenOffice Calc.Direct selection of important system directories like “My Documents”, “Shared Documents”, “Favorites”, “Temporary Files”, “Application Data” etc.įile and directory name with or without directory path,įile name with or without file extensions,ĭate and time of last modification ( back to the year 1601),ĭate and time of creation ( back to the year 1601),ĭate and time of last access (if tracked by the operating system),.Drag & Drop of directories (or files) from Windows Explorer to set a new directory.Selection of directories by entering the path as a text string.(Unicode compatible for Western, Cyrillic, Greek and Asian characters.) Selection of directories to be listed by a tree structure.The application is “DpI aware” and does also properly display with Windows screen scaling over 100%.įree Version (Freeware)and Pro-Version (Shareware) **If you’re a visual learner, I created a video tutorial for this tip.Directory List & Print is Unicode compatible for Western, Cyrillic, Greek and Asian characters. MkDir (ActiveWorkbook.Path & "\" & Rng(r, c))ĩ) Notice that the folders are created instantly.ġ0) Bonus Step: If you want to re-use this Excel workbook and save it with the VBA macro included, you can use File, Save As, and select Excel Macro-Enabled Workbook (*.xlsm) as the file type. If Len(Dir(ActiveWorkbook.Path & "\" & Rng(r, c), vbDirectory)) = 0 Then What if you could add that list of names into Excel, copy and paste some VBA code, push a button, and have the folders created auto-magically for you!ġ) Create a parent folder where all of the new folders will be created.Ģ) Create an Excel workbook and add the list of names to the first worksheet.ģ) Save the Excel workbook into the parent folder from step 1.Ĥ) Select all of cells that contain the names.ĥ) While the cells are selected, press both the Alt key and the F11 key together ( Alt-F11) to open the VBA window.ħ) Copy and paste this VBA code into the module window. Often these lists of names already exist in an Excel file or a Word document. ![]() Additionally, we create folders for deponent names or trial witnesses. We usually create a folder for each custodian name to store their incoming data. In eDiscovery matters, we collect electronic data from multiple custodians. In litigation support, we try to leverage Excel’s functionality for numerous tasks. Please enjoy this blog post tip from Amy Bowser-Rollins, Instructor, Litigation Support Guru.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |