Closed Thread
Results 1 to 2 of 2

macro to transform a dynamic link to a static

  1. #1
    Registered User
    Join Date
    04-10-2021
    Location
    Norway
    MS-Off Ver
    Microsoft 365
    Posts
    6

    macro to transform a dynamic link to a static

    Hi,
    I have a quite large workbook, where i have dynamic links to different sheets.This all works well within excel, but converting to pdf....
    I would like to have a macro that reads these link and writes the static version to a different cell or object.
    The reason for this, is that i need to create a pdf from my workbook and have these links working within the pdf document.

    using the built in, 'insert link'->'within document'->selecting the sheet, works fine when converting to pdf. So i'm hoping a macro could help me automate this process. manually fixing the links this way is not an option.

    Thanks,
    Frank

    The example creates a hyperlink in c1 that changes in relation a1. I would like to have a macro that convert this link to a pdf friendly link that attaches to the textbox(click)
    Attached Files Attached Files
    Last edited by Frank_Aa; 04-10-2021 at 09:18 AM. Reason: adding excel example

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,151

    Re: macro to transform a dynamic link to a static

    Re-posted in commercial services.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to save inputs and link to a dynamic drop down list
    By tml2424 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2020, 12:38 AM
  2. A static-dynamic bar chart - is it possible?
    By rudolflakva in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-29-2020, 07:18 AM
  3. [SOLVED] VBA - Static code to dynamic
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-06-2014, 11:51 AM
  4. MACRO to transform single column to multiple columns, based in dynamic values
    By gaqueiroz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2012, 01:54 PM
  5. [SOLVED] Make Static code Dynamic
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2012, 11:09 AM
  6. Static Cell Value in Reference with Dynamic one?
    By Rick-O-Shay in forum Excel General
    Replies: 1
    Last Post: 01-11-2011, 02:50 PM
  7. Replies: 3
    Last Post: 01-31-2005, 10:06 AM

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