Fast Tip Friday – Create Hyperlinks to All Files in a Folder Using Excel Macro
This fast tip demonstrates how to use an Excel VBA macro to generate a file listing in Excel and then add hyperlinks to each file.
Similar Posts
Fast Tip Friday – Create Folders From List in Excel
When we collect and process electronic data from a number of custodians, we usually create a folder for each custodian to store their data. This fast tip will share a shortcut for creating those folders that can save us a bunch of time. In another Fast Tip Friday, I demonstrated how to create subfolders using an Excel…
Fast Tip Friday – Create ESI Report Using iConvert 2015
Typically, when ESI arrives, the attorney wants to know the volume of documents as quickly as possible. This fast tip demonstrates how to use the free iConvert 2015 software to generate an ESI report.
Fast Tip Friday – Highlight Duplicate Rows Using Excel
This fast tip demonstrates how to use conditional formatting in Excel to highlight duplicate rows, sometimes referred to as duplicate records. In a previous Fast Tip Friday, I demonstrated how to highlight duplicate values using Excel. Download Sample Files
Fast Tip Friday – Batch Rename Adding a Prefix and Padding
This fast tip will demonstrate how to rename generically numbered TIFF files to filenames that include a prefix and zero padding. The tool is a free software program called Bulk Rename Utility. Download Sample Files
Fast Tip Friday – Split Zip Archive Using 7-Zip
This fast tip demonstrates how to create a split zip archive. This is useful if the one large zip file is too large to email or it won’t fit on a single CD. For more information, see my Tools of the Trade series 7-Zip article.
Fast Tip Friday – Search and Redact Regex Text Patterns Using Adobe Acrobat
This fast tip demonstrates how to search for custom text patterns using regular expressions and then redact the text. UPDATE: When searching for the XML file locations, you may need to unhide system files before running the search so that you can see this additional location under your user profile: C:\Users\[user profile name]\AppData\Roaming\Adobe\Acrobat\[Acrobat version]\ Preferences\Redaction\ENU. You can…
This lets you skip a lot of steps needed to setup links in Excel via other means, so you can work faster. Which is really often what it’s all about. It’s also nice that these links don’t use the HYPERLINK formula.
Sean – Glad to hear you enjoyed this one!