+ Reply to Thread
Results 1 to 5 of 5

excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Enschede, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

    Hello guru's

    I have a problem.

    I am using a VBA script which worked fine when I used office 2003.
    This script was created by my colleague how has left the building so to speak.
    I myself have no experience with macro's / VBA scripts.

    When we switched to Excel 2010 it seemed to run fine but with the difference that the images were no longer copied to the worksheet.
    Only a shortcut is added to the cell(s).

    When I e-mail the worksheet the receiver cannot see the images which where added.
    I can see the images in the excel document but only when the t:\ drive is available.
    If I disconnect this network drive then I have the same problem.

    Below is the code:

    Please Login or Register  to view this content.


    Does anyone have an anwser to this problem?
    Last edited by ArjanSpit; 09-10-2012 at 11:18 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

    try this
    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    09-10-2012
    Location
    Enschede, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

    Hello Patel,

    Thanks for your very quick reply.

    But I think I was unclear in posting the complete script in the post.
    The first portion is a test bit and not used anymore.

    The problem lies in the second bit.
    In the "Sub InsertPicInRange".
    The "Sub TestInsertPicture" isn't used.

    Sorry for the inconvenience.

    Never the less I have tried your suggestion but it makes no difference.


    Please Login or Register  to view this content.
    Last edited by ArjanSpit; 09-10-2012 at 11:18 AM.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

    don't use Pictures.Insert use shapes.Addpicture instead because that allows you to specify whether to link or not
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: excel 2010 VBA InsertPicInRange only makes shortcut to image instead of copy of image

    Quote Originally Posted by ArjanSpit View Post
    The problem lies in the second bit.
    In the "Sub InsertPicInRange".
    The "Sub TestInsertPicture" isn't used.
    you have to run Sub TestInsertPicture(), not other sub, don't mix my code with your.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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