Results 1 to 3 of 3

Suggest dynamic (Hyperlink / File path)

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    Pakistan
    MS-Off Ver
    2016
    Posts
    31

    Suggest dynamic (Hyperlink / File path)

    Dear Forum Team,

    I want to use dynamic hyperlinks based on the basis of cell value as image
    Brief Summary:

    1. I want to keep size of the excel file minimum so, i want to use hyperlinks/file path pattern

    =HYPERLINK("D:\Desktop\Desktop\Staff Letter\Staff CNIC\"&E49&".pdf","Click to View")

    Using This formula in CNIC Images column too get required pdf file name in CNIC pattern (00000-0000000-0)

    I want to get required pdf file as per details available in the referred CNIC cell.

    Anyone can help me in this regard.

    Regards,
    Attached Images Attached Images
    Last edited by mngrshoaib; 04-10-2021 at 04:24 AM.
    Muhammad(APFA)
    Query solved,click Stars...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hyperlink Name equal Hyperlink File Path
    By lorber123 in forum Excel General
    Replies: 1
    Last Post: 12-16-2014, 11:08 PM
  2. Need code for hyperlink file path
    By DraftRanger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2014, 01:07 PM
  3. Macro to save sheet as CSV using a dynamic file name and file path
    By chris.tinta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 10:45 AM
  4. File path as hyperlink loop
    By Macro1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:24 PM
  5. Hyperlink File Path
    By lukeois in forum Excel General
    Replies: 1
    Last Post: 05-04-2009, 02:01 PM
  6. Extract file name & path from hyperlink
    By mcs51mc in forum Excel General
    Replies: 3
    Last Post: 04-11-2008, 05:54 AM
  7. Hyperlink File Path Too Long?
    By Jearshub in forum Excel General
    Replies: 4
    Last Post: 01-26-2005, 11:22 AM

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