![]() **If you’re a visual learner, I created a video tutorial for this tip. 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. There are two ways to import data from a text file with Excel: you can open it in Excel, or you can import it as an external data range. In eDiscovery matters, we collect electronic data from multiple custodians. I have found a way of exporting the basic detail using 'Copy as path' but it does not export the date modified and size detail which I require. ![]() ![]() In litigation support, we try to leverage Excel’s functionality for numerous tasks. We want to export the list of files from Windows Explorer to an Excel spreadsheet in order to sort them. 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 |