+ Reply to Thread
Results 1 to 2 of 2

insert image - lookup in different worksheet

  1. #1
    Registered User
    Join Date
    02-21-2010
    Location
    Italy
    MS-Off Ver
    Excel 2013
    Posts
    77

    insert image - lookup in different worksheet

    Hi there, I'm still working on my furniture db and I'm trying to change the insert image function which AndyPope wisely advised me in this thread.
    Now I populate my worksheet via userform, and in there there are no more codenames for the images to be inserted: all the lookup values are in the DATI worksheet.
    I tried to change the code and it works but apparently not completely, since I get odd behaviors if I select certain values/images.
    I attach the xlsm file and some images to best explain which problem I'm experiencing.
    In this workbook I deleted some other worksheets and formulas, but in my 'full' xlsm file I get the same behavior and in addition a 400 error when the sub ends.

    Any hint?
    Thanks in advance..the thanks list is getting long
    P.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-21-2010
    Location
    Italy
    MS-Off Ver
    Excel 2013
    Posts
    77

    Re: insert image - lookup in different worksheet

    Hi there, by re-reading my post I understand I was not very clear in explaining my problem.
    My scope is looking up the picture path in worksheet DATI matching the items descripted in in worksheet prova_userform, column D and insert the image in worksheet prova_userform, column C. Rename in Excel the image with the name of the actual image (i.e. divano.jpg).

    In the previous post I didn't write the full code because it's long and I thought my attached file was enough, but experienced coders may spot my mistakes at a first sight, so..following the full code
    Please Login or Register  to view this content.
    My problem with this code is that I get a 400 code (inserting them) and depending on which images I want to insert in my document it happens I can't delete them..some images are not imported at all
    Obviously my previous code advised by AndyPope which was composing the image path and name from the same worksheet worked smoothly as honey, so all the image links are ok.

    Please help!

    P.

+ 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