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 |