I've recently been given a couple of hard-drives with a large and umanageable number of video files in a couple of folders. I want to create an excel sheet with a list of file names extracted from each folder. Ideally these will be hyperlinked back to the original files.
The hyperlinking I'm assuming needs to be done manually, but can I automate the entry for the list of files?
Have a look at
http://www.vbaexpress.com/kb/getarti...da54213fdf7d82
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
After you've run the code suggested by mudraker, you can concatenate the results to create a hyperlink.
Assuming the directory info extracted takes up columns A:H, then put this formula in I1 and copy down.
then you can hide columns A:H so that I is the only visible column.
Please Login or Register to view this content.
You may need to adjust the formula by adding/subtracting cell refs depending on the length of your paths.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks guys for your replies. I'll give it a whirl....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks