Results 1 to 3 of 3

Thread: VBA to automatically Hyperlink cell text with similar file name
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA to automatically Hyperlink cell text with similar file name

    hi,
    i currently have an excel sheet where i am entering the issued certificates for the jobs done.
    Some examples for the certificate names are
    JAN18/161/C1-C10
    FEB18/185/C1
    FEB18/190/C1 & FEB18/190/MPI/C1

    I have similar names for the files that i save. But the problem is that as windows does not accept "/" in the file name i have replaced "/" with "." in the file names and they look like
    JAN18.161.C1-C10.pdf
    FEB18.185.C1.pdf
    FEB18.190.C1 & FEB18.190.MPI.C1.pdf

    It would be very difficult for me to link them manually, as there are alot of jobs. And there are not just certificates that i have to deal with. i have invoice, quotation, delivery notes with the same requirement.

    Now i want to be able to click the cell with certificate name text and i want the file to open.
    And i want the hyperlinks to update automatically as i put the certificate name. if there is no file with that name it should stay as plain text.
    It would be easier if the color for the certificate name text can change when it gets hyperlinked so that it becomes easier to identify that it has been linked.
    Last edited by fowzan; Feb 8th, 2018 at 06:27 AM.

  2. #2
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to automatically Hyperlink cell text with similar file name

    anyone?

  3. #3
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA to automatically Hyperlink cell text with similar file name

    i dont know if i am allowed tp post link to other forums, but maybe someone who is looking for a similar macro can benefit. i got the solution on an another forum.
    https://www.excelforum.com/excel-pro...ml#post4840186

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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