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 – Generate Word List From Multiple Files
This fast tip demonstrates how to use a free program called TextStat to quickly and easily generate a concordance (aka word list) from multiple MS Word documents. NOTE: If you have PDF files, you could convert them to MS Word format or text format in order to use this software tool.
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…
Fast Tip Friday – Google Tips For Efficient Legal Research
This fast tip demonstrates how to perform efficient legal research on the internet using the Google search engine.
Fast Tip Friday – Highlight Duplicate Values Using Excel
This fast tip demonstrates how to use conditional formatting in Excel to highlight duplicate values within a column of data. In another Fast Tip Friday, I demonstrated how to highlight duplicate rows using Excel. Download Sample Files
Fast Tip Friday – Using the Windows Snipping Tool
This fast tip demonstrates how to create screenshots using the built-in Snipping Tool in Windows. In a previous Fast Tip Friday tutorial, I demonstrated how to use the art of rubber banding.
Fast Tip Friday – Removing Names From Outlook Auto-Complete List
This fast tip demonstrates how to easily remove names from the auto-complete list in Outlook.
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!