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 – Open Link in New Tab Without Right-Click
This fast tip demonstrates how to open any link in a new tab faster than choosing right-click and then Open Link in New Tab.
Fast Tip Friday – Get List of All Folders Using Excel Macro
This fast tip demonstrates how to use an Excel VBA macro to generate a folder listing in Excel. In a previous Fast Tip Friday tutorial, I demonstrated how to get a list of all files in a folder using an Excel macro. Download Sample Files
Fast Tip Friday – Duplicate Current Line Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to duplicate the current line using Notepad++, UltraEdit and TextPad. Download Sample Files
Fast Tip Friday – Search and Highlight and Extract Pages
This fast tip demonstrates how to use an Adobe Acrobat action to perform searches across multiple PDF files, highlight all of the terms and extract the pages that have hits highlighted. The highlight colors available to use in the javascript are listed below: color.transparent color.black color.white color.dkGray color.gray color.ltGray color.red color.green color.blue color.cyan color.magenta color.yellow…
Fast Tip Friday – Column Mode Fill Using Notepad++, UltraEdit and TextPad
This fast tip demonstrates how to use column mode (block mode in TextPad) to replace columns using Notepad++, UltraEdit and TextPad. Download Sample Files
Fast Tip Friday – Remove Password From Multiple PDFs Using Acrobat
This fast tip demonstrates how to use an Acrobat action sequence to remove the same password from PDF files in a folder, including subfolders. Download Sample Files
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!