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.
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.
3 Comments
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!