Insert images in excel

[Harish_saravanan_R]

The images which i am trying to paste are enlarged and they are over lapping . Is there any way i can resize them and paste each image in a totally different cell like one image in I2 and another in E1 like this ?

The pictures are in the folder images , And I have added the excel file too and you see how they are getting inserted in “Sheet 1” . What i want is to insert them in the “Original data” sheet appropriately without overlapping .

Attached the entire file for reference.
ExcelImages.zip (314.3 KB)

[Anil_G (Anil Gorthi)]

@Harish_saravanan_R

change the size of every image to same size…you can use invoke method with resize

and then use macro to change the cell width and height and insert the image

How to Resize the image based on width, height in pixels

Hi, I attached the code resize the image based width and height you just pass the argument input image path ,width,height and output image path I think the information is useful Resize Images.xaml (11.8 KB) Regards Amaresan. P

This is for width …you can simialrly use for height

TRYING TO ADJUST THE WIDTH OF MY EXCEL

@mma You can use a macro or vba as below Sub(sht As String,Rng As String) ActiveWorkbook.Sheets(sht).Range(Rng).EntireColumn.AutoFit End Sub Alternately if you want to set a specific width then we can customize as well Sub(sht As String,Rng As String,wth As String) ActiveWorkbook.Sheets(sheetName).Range(columnRange).EntireColumn.ColumnWidth = wth End Sub Here range call be a single cell in the required column Cheers

cheers

[Harish_saravanan_R]

Sorry i am not clearly getting it. Where should this activity be added in the program which i shared , and what are the inputs for this activity .

[Anil_G (Anil Gorthi)]

@Harish_saravanan_R

in use excel file this activity needs to be added and any argument to be send you can click on add vba argument and add the value

cheers

[Harish_saravanan_R]

Can you share some screenshot for the workflow , it would be helpful for me .