Hyperlink to specific avi file

[mmarshall]

hi i would be greatful for your help,
i have an excel 2010 worksheet with the details of my karaoke tracks( artist track etc) the tracks themselves are numbered ZM00001..2..3 etc
these details are also in the excel doc. I know i can use a hyperlink to just click and go...the problem i have is there are 2500 tracks and i dont want to create these links 1 at a time! any help on a script for a macro etc Please

 

[jbeaucaire]

CREATE HYPERLINKED DIRECTORY LISTING
Here's a macro for creating a hyperlinked listing of files in a chosen directory that match a certain file type (or all). Macro will list the last modified time stamp as well. A sample file is include on the page:

Create Hyperlinked Directory Listing​

You can use this to create a list of all your AVI files in a given folder, then move the Links to where you want them after they're all created.

 

[mmarshall]

Thankyou very much this macro worked a treat!!!