VBA Code for create object on excel sheet to attached multipal pictures file on another excelsheet

[doit_2729]

Hello Everyone,

I am not good at VBA coding, i would be grateful if someone would help me.

I would like to create a button for attachment in excel sheet from where i can attached multiple pictures file which will paste on second sheet or " create automatically pictures tab sheet including pictures.

Thanking youVB

 

[kumarapush123]

The code below will attach File into excel sheet. You can put this code in a loop and replace the "Image_File_Path" with actual file name.

    Thisworkbook.sheets(2).OLEObjects.Add(Filename:= _
        "Image_File_Path", Link:= _
        False, DisplayAsIcon:=True, IconFileName:= _
        "C:\Program Files\Internet Explorer\iexplore.exe", IconIndex:=0, IconLabel _
        :="Image_File_Path").Select

 

[doit_2729]

The code below will attach File into excel sheet. You can put this code in a loop and replace the "Image_File_Path" with actual file name.

    Thisworkbook.sheets(2).OLEObjects.Add(Filename:= _
        "Image_File_Path", Link:= _
        False, DisplayAsIcon:=True, IconFileName:= _
        "C:\Program Files\Internet Explorer\iexplore.exe", IconIndex:=0, IconLabel _
        :="Image_File_Path").Select

Thanks Kumarapush
I dont this is not working for me..either i am doing wrong or i don't know how to do.
i would appreciate if you let me know how to setup

thanks

 

[kumarapush123]

Upload or mail a Sample Excel file with List of Image Filenames along with its complete path.
I will include a macro to that Excel - to automatically attach those image files to sheet2 through a macro.