HOW TO INSERT MULTIPLE IMAGES IN EXCEL IN BULK USING VBA (MACROS) | IMAGES ADD IN EXCEL IN ONE TIME

[@noufalkpm]

very use full

[@md.shamim2532]

This is Very Helpful to Me.

[@henvelarde]

Thanks for this video and code. It really works but I was wondering, if I may ask: How could it be that the files get inserted as object instead of picture format? I'm asking this since if you insert as image and gets adjusted to the cell, then whenever you enlarge the file, it gets blurry. Thanks in advance!

[@gaisanogrand2058]

Thank you

[@kavyajindal9704]

Thanks a lot for the video.

[@ExpertWorld18]

You are welcome

[@MuhammadAbdulAhad]

Good job 👍👍

[@ExpertWorld18]

Thanks 👍

[@TILAKRAJ-ri8ul]

Next sheet mai formula se usth sakti hh kya

[@sayedAhmed-q2c]

Thank you boss❤❤❤❤

[@ExpertWorld18]

Welcome

[@MosesTheExplorer]

how about importing the image in column A and the corresponding title in column B?

[@MohAboAbdo]

Thank you so much

[@ExpertWorld18]

You're most welcome

[@DimitriosMavroeidis]

Thank you!!!

[@VickyKumar-eq7lx]

👌👌

[@lifejourney4151]

Nice

[@ExpertWorld18]

Thanks

[@salamonlaszlolibrarian]

how to do with subfolders included?

[@deepakgupta1903]

Sir mere pas bahut sari photos h mujhe unhe nine images leni h per a4 size paper par or sari photos nikalni h nine nine karke or photo ke upar uska name bhi aa jaye header or footer ki jagah ho

[@jatinlad4491]

Not working on mac OS SONOMA

[@asr632]

Bhai music off karo or voice apni badhao bina ear phones ke apki vdo bilkul bhi sunai ni deti but vdo ne mera bahut bada trouble khatm kar diya thanks

[@ExpertWorld18]

Bhai abhi sound krna thoda muskil hai. But next time iska dhyan rakhuga

[@RahulSingh-rx6hl]

Code kaha h

[@bahar.fashionbuyer]

Hi , dose any one can do this, i try several time and I couldn’t

[@ExpertWorld18]

How can I help you?

[@neelamkumari2215]

Sir ok but i want it in row that how tell

[@ExpertWorld18]

Please download it.
copy and paste in module.
drive.google.com/file/d/1gsfQddqAfSDqQ1DvLUCAAysA0LAnf06k/view?usp=sharing

[@privaldo97]

Can't access file

[@ExpertWorld18]

Sub InsertPictures()
Dim PicList() As Variant
Dim PicFormat As String
Dim Rng As Range
Dim sShape As Shape
On Error Resume Next
PicList = Application.GetOpenFilename(PicFormat, MultiSelect:=True)
xcolIndex = Application.ActiveCell.Column
If IsArray(PicList) Then
xRowIndex = Application.ActiveCell.Row
For lLoop = LBound(PicList) To UBound(PicList)
Set Rng = Cells(xRowIndex, xcolIndex)
Set sShape = ActiveSheet.Shapes.AddPicture(PicList(lLoop), msoFalse, msoCTrue, Rng.Left, Rng.Top, Rng.Width, Rng.Height)
xcolIndex = xcolIndex + 1
Next
End If
End Sub

[@abhishakya5263]

Emp code ke hisab se import karna ho toh

[@ExpertWorld18]

Emp code ke hisab se images rename krni padegi, fir macro run kr skte ho

[@abhishakya5263]

@@ExpertWorld18 thanks

[@Ifrahirfan97]

please send me code

[@ExpertWorld18]

Link given in description box

[@manorjangid]

​@@ExpertWorld18 link not working

[@sangeetarai320]

Audio bahut kam hai kuch samajh me nahi ata , aap log aise vdo bante hi kyun hai.

[@ExpertWorld18]

I am a new creator, Just learning