+ Reply to Thread
Results 1 to 6 of 6

Hyperlink Friendly Name as File Icon.

  1. #1
    Registered User
    Join Date
    02-02-2010
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    47

    Hyperlink Friendly Name as File Icon.

    Hi,

    I was wondering if its somehow possible to have a hyperlink formula display the file-icon as friendly name?
    I'm not sure if this is possible with regular formulas or if a VBA is needed to get this result?

    thx.
    Last edited by Bluewhistler; 02-09-2010 at 07:09 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Hyperlink Friendly Name as File Icon.

    which file icon? You can insert an image into the worksheet and put a hyperlink on the image.

  3. #3
    Registered User
    Join Date
    02-02-2010
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Hyperlink Friendly Name as File Icon.

    The file that is linked in the formula. So it could be any file.

    Please Login or Register  to view this content.
    Where A1 is C:\any-location\any-file.xxx

    I would like to have the icon displayed in the cell if this is this possible?

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Hyperlink Friendly Name as File Icon.

    Don't think you can do that with formulas, not sure if this is possible even with VBA.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Hyperlink Friendly Name as File Icon.

    You can insert a picture as the icon, and add a hyperlink to the picture.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    02-02-2010
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    47

    Thumbs up Re: Hyperlink Friendly Name as File Icon.

    Quote Originally Posted by teylyn View Post
    Don't think you can do that with formulas, not sure if this is possible even with VBA.
    I had a feeling this would be difficult or not possible.

    Quote Originally Posted by shg View Post
    You can insert a picture as the icon, and add a hyperlink to the picture.
    Probably going to do it like this!

    Thx guys.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1