+ Reply to Thread
Results 1 to 10 of 10

VBA - "The linked image cannot be displayed" when file is sent with image embedded

  1. 10-19-2018, 07:55 AM #1
    f41yaz
    f41yaz is offline
    Registered User
    Join Date
    09-12-2018
    Location
    Leicester
    MS-Off Ver
    2007onwards
    Posts
    32

    VBA - "The linked image cannot be displayed" when file is sent with image embedded

    Hi guys,

    You probably have better things to do on a Friday but I would be most grateful fi you could help with the following issue.

    My sheet has the following code which allows users to insert an image into the file which works fine but when they send the file to someone else via email, the image does;t show and is displayed with message ""The linked image cannot be displayed. The file may have been moved, renamed or deleted. Verify that the link points to the correct file and location."

    Please Login or Register  to view this content.
    Any idea how to overcome this so the image is embedded into the file and not linked to a location?

    Thanks for all your support.
    Reply With QuoteRegister To Reply
  2. 10-19-2018, 08:34 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    A bit opposite to common understanding, instead of inserting a pisture (which shall insert but does not), have you tried to add picture as a shape?

    Please Login or Register  to view this content.
    objPic properties below could also need adjustments (may be .ShapeRange before lockaspectratio skipped, etc.)
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 10-19-2018, 08:56 AM #3
    f41yaz
    f41yaz is offline
    Registered User
    Join Date
    09-12-2018
    Location
    Leicester
    MS-Off Ver
    2007onwards
    Posts
    32

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    Like this:?

    Please Login or Register  to view this content.
    It doesn't seem to like it. Compile error occurs and ".Addpicture" is highlighted.
    Last edited by f41yaz; 10-19-2018 at 09:00 AM.
    Reply With QuoteRegister To Reply
  4. 10-19-2018, 09:12 AM #4
    f41yaz
    f41yaz is offline
    Registered User
    Join Date
    09-12-2018
    Location
    Leicester
    MS-Off Ver
    2007onwards
    Posts
    32

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    I have noticed a paste special would slove the problem. Any idea how to add that into the code?
    Reply With QuoteRegister To Reply
  5. 10-19-2018, 09:17 AM #5
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    Try such modification (left, etc inserted into addpicture already:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 10-19-2018, 09:21 AM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    AddPicture requires 7 arguments, not 3. So you need:

    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head
    Reply With QuoteRegister To Reply
  7. 10-19-2018, 09:22 AM #7
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    That's what I autocorrected :-)
    Reply With QuoteRegister To Reply
  8. 10-19-2018, 09:31 AM #8
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,282

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    Sorry, I was addressing the OP - I hadn't seen your response as it came in while I was typing mine.
    Reply With QuoteRegister To Reply
  9. 10-19-2018, 09:34 AM #9
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,650

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    No need to be sorry. Anyway with a full set of arguments it shall work fine, so let's wait for comment from OP
    Reply With QuoteRegister To Reply
  10. 10-19-2018, 10:03 AM #10
    f41yaz
    f41yaz is offline
    Registered User
    Join Date
    09-12-2018
    Location
    Leicester
    MS-Off Ver
    2007onwards
    Posts
    32

    Re: VBA - "The linked image cannot be displayed" when file is sent with image embedded

    Brilliant that solved it!!! Thanks Mate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make an image "draggable" within an image control rather than scaling it
    By jerH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2017, 01:56 PM
  2. Excel 2010 "vlookup pictures vba" links image instead of saving it as an image
    By neverdom in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2013, 04:17 AM
  3. Extract and display image URL from "Linked image cannot be displayed" pictures
    By apyken in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 12:12 PM
  4. Excel 2013 is reporting "This image cannot be displayed" when I use the Camera tool?
    By Cam in forum Excel General
    Replies: 0
    Last Post: 06-25-2013, 10:44 AM
  5. Extract and display image URL from "Linked image cannot be displayed" pictures
    By apyken in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2013, 09:52 PM
  6. Extract and display image URL from "Linked image cannot be displayed" pictures
    By apyken in forum Excel General
    Replies: 2
    Last Post: 05-12-2013, 09:51 PM
  7. [SOLVED] image/file renaming within "image/file sets"
    By yozangwu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-24-2013, 09:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1