none
How to insert multiple images into excel cell with autofit using VBA. RRS feed

  • Question

  • Hi.,

    I want macro vba code to insert multiple images into excel cell as per below steps.

    insert images into column (A:A) and using image names from column (B:B)

    1) using input box for folder path where all files stored.

    2) insert image using imagename (like :- 210789.jpg).

    3) if image name not available in column .for eg. B1 , B2 , B3 having image name , B4 not having image name but B5 having image name then go to next B5 and skip B4.

    4) Image Auto fit to column.

    If someonen guide ,Its very thankful to me or other who are looking for the same .

    Thanks in advance.

    Tuesday, May 12, 2015 2:43 PM

All replies

  • Hi..Any updated that how to do this in Excel VBA 2007.
    Wednesday, May 13, 2015 6:16 PM
  • Look at this.  It is close to what you want.

    http://www.learnexcelmacro.com/wp/2013/06/insert-a-picture-in-excel-using-vba/

    Another one is:

    http://www.exceltip.com/general-topics-in-vba/insert-pictures-using-vba-in-microsoft-excel.html

    Thursday, May 14, 2015 12:31 PM