+ Reply to Thread
Results 1 to 2 of 2

VBA to create absolute hyperlink

  1. #1
    Registered User
    Join Date
    06-19-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    2

    VBA to create absolute hyperlink

    Hi everybody,

    I am an intern working on an excel reference page for my coworkers that lets them reference drawings. These drawings are hyperlinks. My issue is that I need these drawings (and their corresponding info) in their own Excel sheet as a separate file and these files are then copied directly to a master reference page I am working on. Since, I am copying them, I need these hyperlinks to be absolute so I do not lose the path when copying. I have used the "=hyperlink" and typed in my URL and that works perfectly. The issue is I am leaving this program with less computer savvy coworkers that would not understand the hyperlink function. Is there anyway to create a VBA/button that opens up a dialog box and lets them choose their file and it posts the ABSOLUTE hyperlink? All of these hyperlinks will be in column J. I have used "Application.Dialogs(xlDialogInsertHyperlink).Show" but that only creates the relative. Thank you!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,613

    Re: VBA to create absolute hyperlink

    Here's a link to a blog that offers a tip on how to force the Insert Hyperlinks dialog make absolute links. I haven't tried this myself, but it sounds interesting. Report back if it worked for you.
    Excel Hyperlinks -- Relative vs. Absolute Path

    Alternatively, this example code will prompt the user for a file and insert the selected path in a =HYPERLINK formula.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  2. Replies: 2
    Last Post: 07-13-2013, 12:37 PM
  3. Replies: 2
    Last Post: 07-12-2013, 05:46 PM
  4. Replies: 0
    Last Post: 10-10-2011, 05:11 PM
  5. create a hyperlink back to a previous hyperlink
    By JT_Krupa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-21-2011, 11:22 AM
  6. Absolute Hyperlink Address
    By starryknight64 in forum Excel General
    Replies: 2
    Last Post: 09-28-2006, 09:04 AM
  7. How do I create a hyperlink to a cell with the hyperlink function
    By S. Bevins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2006, 03:06 PM
  8. Absolute hyperlink
    By Robert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2006, 12:00 PM

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