+ Reply to Thread
Results 1 to 5 of 5

How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

  1. #1
    Registered User
    Join Date
    04-03-2019
    Location
    Brazil, SP
    MS-Off Ver
    2010
    Posts
    7

    How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

    Hello friends,

    I'm using a code below to capture a determined area from my excel and then send via e-mail.

    I wish some help to put hyperlinks like "youtube" or "random websites" inside this image.
    So anyone who receive this image can "click" in the link and go to website or youtube



    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    04-10-2019
    Location
    Kansas City, MO
    MS-Off Ver
    Microsoft Office 2016
    Posts
    3

    Re: How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

    Could you provide a little more clarification on what exactly it is that you're trying to accomplish?

    In the above code, it appears that you're copying a range as a bitmap image, which is not a format that supports embedded hyperlinks.

  3. #3
    Registered User
    Join Date
    04-03-2019
    Location
    Brazil, SP
    MS-Off Ver
    2010
    Posts
    7

    Re: How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

    Hello Kristen,

    Like when I see a picture in some aleatory e-mail and you can click in that picture, which send you to some website, etc..

    Maybe I need to change my code? But which format I need to use?
    Could you help me with the code?

  4. #4
    Registered User
    Join Date
    04-10-2019
    Location
    Kansas City, MO
    MS-Off Ver
    Microsoft Office 2016
    Posts
    3

    Re: How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

    There's nothing wrong with your code; the issue is that what you're trying to accomplish can't be handled with Excel VBA alone. The hyperlink functionality you're wanting to include in an email would have to include Outlook VBA and potentially a bit of HTML as well--because even after pasting clipboard contents to an Outlook email, VBA cannot assign multiple hyperlinks within a single image.

  5. #5
    Registered User
    Join Date
    04-03-2019
    Location
    Brazil, SP
    MS-Off Ver
    2010
    Posts
    7

    Re: How put MULTIPLE hyperlinks, in multiple points of the image, in a image from excel

    Kristen, could you help me with the code to change the type?

+ 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] Placing & Resize Multiple Image in Excel
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2017, 06:52 AM
  2. Insert Image With Image Filename In Another Cell - Excel
    By Angelq117 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2016, 09:38 AM
  3. EXCEL, VBA, Image: Image loses transparency after saving woorkbook
    By lhasha in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-19-2016, 11:13 PM
  4. [SOLVED] How to apply Image borders to an image that my excel vba userform pastes in a word doc?
    By CaptainCool in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 05:40 PM
  5. Assign Macro with Multiple Parameters to Image (Excel 2003)
    By zeuscartwright in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 04:24 AM
  6. VBA: Put text from excel to jpeg image by matching image name.
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 01:47 AM
  7. excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image
    By ArjanSpit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2012, 02:57 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