Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jun 2009
    Location
    Brisbane, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating bulk hyperlinks in Excel

    Hi,

    Hoping someone can help. I have a subdirectory with approx 6000 photos in it, named so that they occur in a specific sequence. I have a second subdirectory that contains a series of word documents that tell the story of the each photograph, also in the same sequence. I have an excel spreadsheet with the list of photos (in identical specific sequence) and a second column with the matching documents and I would like to hyperlink to each photo to the list, and then in the second column, to each explanatory document. Is there any way to create bulk hyperlinks?

    Thanks in anticipation

    Wyldchild

  2. #2
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 8 Times in 8 Posts
    Are the values in the first and second column completely qualified file names, including drive and subdirectory?

    Can you post an example of the first few lines of your Excel file?
    PJ in FL

  3. #3
    New Lounger
    Join Date
    Jun 2009
    Location
    Brisbane, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    No they are not file names - the actual file names are something along the lines of R 10011-00,00250,00015,15_50_46,21-03-2011.doc (or .jpg) - there is a reason and logic to the file names. For the spreadsheet, it is all simplified for readablility. The highlighted red bit above becomes the name of the link eg PSN 00015. I have attached a sample. In the real spreadsheet, there will be missing numbers in the sequence eg photo 00001, 00005, 0009 etc.

    Thanks
    Attached Files Attached Files

  4. #4
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Chip Pearson has code to create a folder/file listing here...
    http://www.cpearson.com/excel/FolderTree.aspx
    You could create two separate lists and copy/paste both of them on a new sheet.

    There is at least one commercial alternative.
    '---
    Jim Cone
    Portland, Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    (List Files XL add-in: finds and lists files/folders with hyperlinks)

  5. #5
    New Lounger
    Join Date
    Jun 2009
    Location
    Brisbane, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wink

    Thank you Jim - a brilliant solution - and thanks to Chip Pearson too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •