+ Reply to Thread
Results 1 to 3 of 3

Insert/Delete Multiple Pictures but 1 or more pictures not available

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Insert/Delete Multiple Pictures but 1 or more pictures not available

    Hi All!

    Brand new to this site and I have only dabbled in VBA. What I am working on is trying to skip an insert picture for a part of the code that I put together from different sites (no credit can be taken for the following code). I have a reference number 123 then a picture in a file named 123.jpg, 123_2.jpg, 123_3.jpg. Some may only have 1 or 2 corresponding pictures and my code fails inserting the third. I might need an if statement but not quite sure how to word it. Any thoughts? Thanks in advance.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    08-28-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Insert/Delete Multiple Pictures but 1 or more pictures not available

    It looks like I solved the problem by inserting this code.
    Please Login or Register  to view this content.
    However, it will now insert my first picture in the cell where "Picture3" should go "F90".
    Please Login or Register  to view this content.
    Last edited by MrNoodles; 08-28-2012 at 12:46 PM. Reason: wrong code

  3. #3
    Registered User
    Join Date
    08-28-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Insert/Delete Multiple Pictures but 1 or more pictures not available

    Ok, I would assume this is much more messy than it should be but I've got everything showing in the right places and returning nothing if there is no corresponding picture. Thanks, I think?

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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