How To Insert Multiple Pictures at Once In Excel│एक से ज्यादा फोटो कैसे इन्सर्ट करे एक्सल में।

This video is about How To Insert Multiple Pictures At Once In Excel? or you can say Insert multiple pictures into Excel with VBA code.
Insert multiple pictures in Excel at once, how to insert multiple photos in excel
Excel-VBA : Insert Multiple Images from a Folder to Excel Cells
The Insert Pictures add-in takes multiple images of your choice and fits them into separate cells. You decide how many pictures to insert and where to insert them - in a column or row. Also, you choose what size the images should be: pictures adjusted to cells, cells resized to accommodate images or any specific size that you set.
It is easy for us to insert one picture into Excel, but if you need to insert multiple pictures at once so that can save much time, how could you do?
Say you have many images in a folder and you want to insert all these images in your excel work book, one image in one cell. You can do it manually, insert and resize the image and drag it to the particular cell, but think of a scenario where you have more than 100 images or may be more. I am sure you don’t want to do it manually. IF you are looking for solutions for problems like this, this is the tutorial for you.
This tutorial will teach you about how to insert multiple images from a folder into your excel.
With the following VBA code, you can insert multiple pictures into Excel file cell by cell.
1. Select a range that you want to insert pictures.
2. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
3. Click Insert - Module, and paste the following macro in the Module Window.
====@@@Click Below Link to Download Multiple Photo VBA@@@====
Link 1: drive.google.c...
Link 2: mega.nz/file/e...
======================================================
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)
xRowIndex = xRowIndex + 1
Next
End If
End Sub
======================================================
4. Then press the F5 key to run this code, and select the folder which contains the pictures that you want to insert. Then specify the pictures as you need. And click the Open button.
5. And all the selected pictures have been imported into your selection based on the cell size.
This is the video to insert multiple pictures into excel with VBA code
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u

[@sonigajanand]

Bhaut hi shandar ese trik wastav me interest jagate hai sikhne me

[@9821399236]

Superb superb superb sir...lot lot lot thanks for you.....God blesses you in your entire life.... Lots of thanks t

[@ComTutor]

Thanks for lots of blessings, i will share my knowledge like this, in return please share this video and do like and subscribe us.🙏

[@nehapande1321]

Thank you so much for this!!! Had to make an excel of 2000+ candidates with their photos as well. This helped me a lot!! 🙏🙏🙏🙏🙏🙏

[@nayabkazi]

Thank you for the VBA coding it help us a lot, just a quick question how we can add vertical and horizontal sheet column photos, is any way to add photos vertical and horizontal in columns. Thank you

[@hpkhan7613]

Very Smart Trick & Thanks

[@ComTutor]

Thanks

[@arpanabani4302]

please please make a video on what is .csv file and how to upload products through .csv file on pintrest..

[@rajeshrajbabu123]

Thank you for simply the issue I have one query can we insert multiple image with image name in another column if so please help

[@brandoncomfort2494]

Great ! but how can insert selected images by name or by code name in selected cells. thanks

[@rv.prabhudankashyp8491]

👌1👌

[@ComTutor]

Thanks

[@senthilrajan8100]

Its Working. Thanks you so much.

[@amarsonkar8772]

Thanku so much sir aapne Mera pura time bacha diya

[@prahalladjena1634]

Excellent, i want to know how to do in Google sheets

[@shyamsunderpandey5702]

Very easy tarike se VBA sikhaie guruji. Thanks. Radhe Krishna.

[@ComTutor]

okay now i'll start it

[@gajendrasingh9486]

Very helpful...can u make video for vba for email with pic image

[@wasimraza2303]

Supper well done 👍 perfectly working fine thank you 😊

[@ComTutor]

thanks

[@dhirukdhmake7997]

Thqnkx bro for providing valuable information

[@patelazaz9527]

Thank you thank you thank you sir you are so Awesome this trick is Amazing. it's working.

[@trincoboys5860]

Hi sir How to export picture from excel to desktop folders please make video

[@ashwinverma1829]

Sir I want to insert images in two columns, as u did in one colomn, can you please explain the process for that

[@ComTutor]

Create 2 folder for 2 column and asperated all images for column 1 and 2 in respective folders. then 1 by 1 apply this video trick by selecting folder 1 for 1st column and folder 2 for 2nd column. Your desire work will be done in 2 steps.

[@eliezergill6919]

God bless you bro..Thanks for sharing

[@dreamlandtechnologylimited7576]

This video was very helpfull.

[@ComTutor]

Thanks

[@HODPhysicsGLDMGDCHiranagar]

Thanks a lot for this informative vedio and sharing the VBA code👍👍✌

[@amrashoecompany2410]

Sir will it work in MacBook ?

[@rimmixhaid]

amazing trick thank you so much. God bless you

[@FORYOU-wb1rx]

Great

[@gauravsagar301]

Thanks for a great solution.

[@dawnsil]

Dhnyawad bhai, mujhe bhi 90 fotos add krni thi, kaam jldi hogya is tarikey se

[@swatijain1616]

AMAZING VIDEO.. JUST CHECK THAT DEVELOPER TAB IS ON

[@trincoboys5860]

Yes can insert but how to auto resize and fix to the cells all photos pls help me

[@puneetvij8433]

Govind Sir, देर आए मगर दुरूस्त आए | यह मेरी query थी, बहुत बड़िया solution दिया है, thanks! ; )

[@ComTutor]

thanks, Puneet agar aap ye comment pehle kar dete to maybe mei pehle hi video bna deta.

[@VijaySharma-lo7ix]

Govind how I can I download VBA code

[@NareshKumar-fr3xz]

Very Nice, but jab photo ko print karte h to vo dhire dhire photo apni jagah niche hoti jati h..... Dusre column tak pahuch jati h.... Esa kya kare ki photo apne column me hi rahe....

[@vedantsharma5936]

Shandar video 👌

[@ComTutor]

thanks Vedant

[@abhinavnishad7819]

Thanks 🙏🙏

[@sultanmahmud6176]

Many many thanks bro.its awesome u saved my 6 hours .just inserted a lot of pic by this trick.

[@ComTutor]

Thanks

[@mastermyndgoa]

Sir it's great trick, can u share location of ur vba code

[@ComTutor]

Thanks bro, but i have already shared Vba in video description

[@rameshsahil3486]

This video Helped me a Lot..

[@ComTutor]

Thanks 👍

[@manaskumardas1683]

Thanks, this VBA code really helpful. I am expecting more video related to multiple insert like name wise insert.

[@ComTutor]

Will try to make video on this topic

[@parveenkoli4054]

Thank you sir apne ganto ka kaam second me kara dia thank you

[@santosh9555]

VERY GOOD INITIATION SIR.......THANKS AND BLESS YOU..

[@ComTutor]

Thank you sir

[@oonjanaadhikari2685]

after pressing F5 I couldn't find that screen as yours. plz help me out

[@MrTechi1984]

How can insert multiple photos in name wise? Please suggest.

[@sariyamehakvoice2648]

Super

[@flyingvikash56]

Thanks

[@funshun215]

thanku man its helpful

[@ComTutor]

thanks

[@sandipthakare9296]

Thank u bhai

[@newcreator1024]

How to add same picture in entire work book plz help🙏🏻

[@umamaheswari.b5289]

Thank you Brother

[@ComTutor]

Thanks

[@ghazanfarabbas3141]

Hello sir mery pas 1 csv ki file ha or 60k images hain csv ki file Id k sath images ki I'd ko ley k ana chahta hn please help me

[@pratshuk]

Thanks 🙏 a lot its wonderful

[@anzarsaeed1171]

Hi thanks a lot for sharing it ..

[@yasirjamal8019]

Keep up the good work. U r a time saver.

[@ComTutor]

Thanks bro

[@shrikanttumdam7476]

Thanks you sir for this VBA ..but I need one more help. This photo aslo resize into 4 x 6 ratio without setting the excel cell size.. I want to set all pic in standerd size given by me..

[@shrikanttumdam4001]

Please help us

[@SaviorVlogs]

Nice work.. it helped me lot

[@ManojKumar-gt5tw]

Thanks! great i am waiting for such type of tricks. Can you give such type of micro/ trick that, In excel i already have photo no. in a column in respect to this photo no. i want to insert only those photo with match to photo name.

[@JOBIN2190]

Great, thank you

[@shraddhamaurya6539]

Thank you so much ....😊 you saved my time

[@Memes-Master]

Woh link file send kar doh mushe bhai

[@lokeshmehta5026]

Thank you

[@ComTutor]

You're welcome

[@wisdom6055]

Bhai muje ek cell me pic ke multiple name dalne.. hai kise kru...?? For my website

[@oneopportunity9593]

Thanks brother it is very helpful

[@chayanize]

how can i use this in macbook ?

[@deeptis174]

Thanks very helpful

[@ComTutor]

Glad to hear that!

[@ManojKumar-zd1uz]

bhai tum genious ho aur apka link perfectly kam kiya...thank you so much.

[@ComTutor]

Thanks

[@rehmanata6612]

Does it work in excel 2013

[@ComTutor]

yes will work in all version

[@ranigunjimpex9442]

thanks alot

[@ComTutor]

Welcome

[@funwithsid1330]

Thank you bhai

[@ComTutor]

welcome

[@ritudhwaj4470]

Lovu brother

[@sagarsahare3054]

SIR, VERY NICE...

[@rv.prabhudankashyp8491]

Thanks a lot 👌

[@ComTutor]

Thank you

[@pramodsutar9995]

Awesome

[@mamtapurve]

Sir how to do it in two raws please reply

[@comradedavid]

its very good for knowledge and thank you for also smart work.

[@vasupadh6111]

thanks for helping

[@lokdeepsahu663]

Thankyou sir this trick is working 👍🏻

[@shuhaibpt6913]

What is alternate key for alt + f11 in Mac book

[@ComTutor]

FWIW - Alt(Opt)-F11 is absolutely the default keyboard shortcut to enter the VBE on the Mac. If you've got your System Preferences set to use FN keys to dim the screen, set volume, etc., then you need to press the fn key as well as Alt(Opt) & F11.

[@farhanahmed8006]

How we can prepare VBA for pics?

[@umamaheswari.b5289]

Super Brother

[@shaguftakhanum4520]

zbrdastttttt

[@kaushambihorticultureoffic7659]

Description dba formual kaha hai

[@octaviobahia]

Thanks for the Excel-VBA coding👍👍👍

[@ComTutor]

You are welcome!

[@vijendrasawant6223]

Hi sir Mobile me kaise kare ??

[@muhammadzada4202]

Good thank you

[@Jacquardfab]

How to make a bill invoice while making a GST bill

[@viranchivedpathak4231]

Amazing. Thanks!

[@MrGurpreetmaan]

word mein kaise hoga pl try to explain.

[@RohanKhune-zm5oe]

Superb ❤️

[@kaveeshpruthi]

Bhai aise mobile mein kaise kre

[@VIJAY100ify]

IMAGE KO SEQUENCE ME KAISE PASTE KARENGE

[@ComTutor]

Aap only folder mei sequence mei photo ko save karo uska naam rakh kar. phir jab photo insert karoge to apne aap sequence mei aa jayega

[@neerajkukrejaneeraj9478]

Thank you so much to share this video, It's really helpful, But i want to insert the muliple pictures accoring on code number, suppose i give 1-10 code no. but in the excel sheet code number is not serial vise , in the excel list code no. like this 10,5,7,8,9,4,3 , so is it any way to insert the picture agaist's is name, plz share the soluction, thanks

[@ajaygupta4188]

Helpfull 👍🙏

[@ComTutor]

Thanks for liking

[@3dgurjar825]

jo photos insert kari hai un photos ka name bhi chahiye tou kya karu ??

[@saikumarorsu952]

Tnx

[@35atif]

How can we put photos in row

[@ComTutor]

Uska bhi vba banana padega, abhi nhi hai but create kar dunga

[@anilgavankar7690]

V dry nice

[@pareshpatel1762]

Very good .

[@ComTutor]

Thanks

[@najmulgani2814]

your video is so help full

[@ComTutor]

thanks for the complement.

[@hemantsharma2501]

Sir accending order main nahi aa rahi hai

[@ComTutor]

Accessing order mei pehle saari images ka naam save karna hoga, phir aayega

[@thousifahmed1337]

Whr I will get VBA

[@ashfaqalam9023]

sir Picture Upar ki or khisak ja rha, Cell me fit nhi ho rha thik se

[@rpsingh4137]

Mere mein nhi ho raha hai koi salusion batao please

[@raqiaztashna6787]

Dear Sir, I am from Pakistan (KPK, Bannu). Sir, Zaberdast Video hay. Sir, agar ak cell ke chor kar dusray awr tisray Cell ko chor kar Chotay is tarah musalsal cell ko chor dusray Cell may Picture Insert karni ho tu wo kaisay ho ga . Sir Please Reply i am wating for your reply