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 Dropdown List From Another Workbook
This fast tip demonstrates how to create a dropdown list in an Excel workbook that pulls in values from a list in another workbook. In another Fast Tip Friday, I demonstrated how to create a dropdown list from another worksheet. 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
Fast Tip Friday – Endorse PDFs Using Adobe Acrobat
During a litigation matter, there is often a need to produce documents in PDF format. This fast tip demonstrates how to endorse PDF files for production. Download Sample Files
Fast Tip Friday – Capture a Screenshot of a Web Page Using SnagIt
This fast tip demonstrates how to use SnagIt to capture a screenshot of a scrolling web page.
Fast Tip Friday – 3 Privacy Tips For Your LinkedIn Profile
This fast tip demonstrates several tips for controlling the privacy of your LinkedIn profile. If you don’t have a LinkedIn profile, you should definitely create one. Nowadays, all professionals are expected to have one. Not having a LinkedIn profile can leave a poor impression.
Fast Tip Friday – Get List of All Files in a Folder Using Excel Macro
In a previous FTF video entitled Using DOS to Create File Listing, I demonstrated how to use DOS commands to create a file listing. This fast tip demonstrates how to use an Excel VBA macro to generate a file listing in Excel. In other FTF videos I have demonstrated how to use Excel VBA macros…
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!