Thank u so much for Sir i was searching past one month now the problem is resloved...Thank u for this amazing service , God Bless u Sir..Thank u so much again..
Thank you Sir B is in column number from row number 5 to 1,2,3, in the same order there is photo folder in path P also photos are also in number 1,2,3 they want to take in column 35
Hi Sir, can i get some help. I am not sure if all the images are in the folder, so if any images are not there i would like to have a msg as "Not found" and also an additional command button to clear all the images. Can i get that VBA codes as well which will make my life more easier
Hello Sir, may get some help? I need to insert hundred of pictures into my product list with respective codes. I have save the pictures with the code in a folder which match with my product list code. However, the pictures are still unable to appear on my product list even I click on > developer > macros > run > import images > select import pictures location from the folder. May I get your help? I can share the product list and pictures files to you. Appreciate for your advice this
Hi! This is a great tutorial. But, in my case it did not work! I followed the instructions but when i click the button, a message box was appeared "Object does not support this property method or method". I show the code. The problem is on the line "Set animal_pic = ActiveSheet.Pictures.lnsert(pic_location)". What's ii wrong? What can i do to solve the problem?
Thank u ver much for the video I need some help though, when i send the file the images dont open, because of the path Is there any way to fix it? Pleeeease
Thank you very much, sir, for this great video. If possible I have a question: How can pictures be renamed as rows?for example copy2, copy3, copy4 etc.... With VBA.
Can I take a picture I put in the excel and use them in vba forms without loading from somewhere else? I putted a picture in one of the sheets and I want to use that picture in a form is it possible?
@@ExcelDestination I'm having difficulties, can you tell the code you are using to do this? If it's in the video tell me exactly where, I kinda got lost
Thanks for your great tutorial. I have a request. If I use this with a data validation list and press the command button the refresh the images the previous image are still there underneath the new ones. Is the a command I could use to delete the previous image before placing the new one? Thanks again!
when I click on Insert Picture, It is not taking any action but when I check vba code then it shows error on line no. 6 & showing range error. I am calling cheques as I have needed from folder but 1 thing more if my pictures are in jpeg, jpg, png or other format so how can I call Kindly suggest me on both my queries. Thanks
this is really good thing to save time. But when I tried it I got a dialogue box of RUN TIME ERROR " Unable to get the insert property of the picture class" but when I changed my pictures name from IMG_20200815_085825 to any word name it will work. Can you help me to work this without changing my pictures name??
Hi, Can you help me to unlink the image path of the inserted image by VBA code in excel and save image in the same cell by VBA please. so that I can send the file to others.
Hi i am get error the "Set animal_pic = ActiveSheet.Pictures.insert(pic_location)" Run-time error "1004": Unable to get the Insert property of the Picture class
Bro I am pulling data from nse website option chain I want first highest second highest oi data paste into another sheet how to do that and sheet is refreshing automatically 5 minutes and ever time data come in new row
For a code that works correctly if the direction of the paper is from the left. And it's wrong if the direction of the paper is from the right... How to make the image appear in its correct place if the direction of the paper is from the right
Sir . Also error of unable to get insert property in picture class comes when we select one item. Ie, picture against one item. Pls help to solve this also. If all 5 items we select them no error
Very helpful... I like your videos.... I have one query that I m working in HR department...I need to send 30 to 40 mails daily using Gmail account ...will you make video for sending emails using Excel VBA via Gmail instead of outlook... Please help me..it will save my time...
الكود يعمل بشكل صحيح اذا كان اتجاه الورقة من اليسار ..ويخطا اذا كان اتجاة الورقة من اليمين...كيف يمكن جعل الصورة تظهر في مكانها الصحيح اذا كان اتجاه الورقة من اليمين
without looking at your code, not sure what is the error. you can send me your file, I can check and let you know. If you need my file, send me email at exceldestination@gmail.com I will provide you the original file, which is working perfectly. Hope this helps!!!
I have tried it but after writing the code when I go to Sheet and click over it that returns error of not assigning Function or Sub. Could u pls tell me why I am having this issue/
Thank u so much for Sir i was searching past one month now the problem is resloved...Thank u for this amazing service , God Bless u Sir..Thank u so much again..
Hey, I just wanted to say this video helped me out quite a bit and I really appreciate the time you took on it.
Glad to hear it!
This Video has helped me a lot to make my life simple. Thank a Lot
Excellent Sir.,.
Thanks
Thank you Sir B is in column number from row number 5 to 1,2,3, in the same order there is photo folder in path P also photos are also in number 1,2,3 they want to take in column 35
Hi Sir, can i get some help. I am not sure if all the images are in the folder, so if any images are not there i would like to have a msg as "Not found" and also an additional command button to clear all the images. Can i get that VBA codes as well which will make my life more easier
Excellent video! Thank you.
Glad it was helpful!
Hello Sir, may get some help? I need to insert hundred of pictures into my product list with respective codes. I have save the pictures with the code in a folder which match with my product list code. However, the pictures are still unable to appear on my product list even I click on > developer > macros > run > import images > select import pictures location from the folder. May I get your help? I can share the product list and pictures files to you. Appreciate for your advice this
Hi! This is a great tutorial. But, in my case it did not work! I followed the instructions but when i click the button, a message box was appeared "Object does not support this property method or method". I show the code. The problem is on the line "Set animal_pic = ActiveSheet.Pictures.lnsert(pic_location)". What's ii wrong? What can i do to solve the problem?
Great !, thanks
Welcome!
Merci beaucoup
Welcome
Thanks sir
This video can be help me. Thank you.
Glad it helped
What to do on error? When i don't have the picture my excel close.
Awesome 👍👍
Thank u ver much for the video
I need some help though, when i send the file the images dont open, because of the path
Is there any way to fix it? Pleeeease
Thanks
Welcome
@@ExcelDestination yeh practice file Kahan se download kar sakta hun sir ?
Thank you very much, sir, for this great video. If possible I have a question: How can pictures be renamed as rows?for example copy2, copy3, copy4 etc.... With VBA.
i Have a macro, in Office 2007 working, but in not working in Office 2010,2013,2016 can u help me
Can u help in providing the module for the picture in the user form to be directly transfer in the Excel form also
Can I take a picture I put in the excel and use them in vba forms without loading from somewhere else?
I putted a picture in one of the sheets and I want to use that picture in a form is it possible?
yes
@@ExcelDestination I'm having difficulties, can you tell the code you are using to do this? If it's in the video tell me exactly where, I kinda got lost
Really nice. ..
Taiyyab 👨💻👨💻✏️📝🧾✒️📅
Thanks a lot 😊
Sir super video , but can't run the program , some error , application & object error sir pls clarify
Thanks for your great tutorial. I have a request. If I use this with a data validation list and press the command button the refresh the images the previous image are still there underneath the new ones. Is the a command I could use to delete the previous image before placing the new one? Thanks again!
Yes, you can
798 he 3 c Nrfj4 we u, mananiy Valentine De ki Nikki
what if i want to make the cell ready for any object or image
Sir, Could This code work to find picture Folder and into the Sub Folder also
yes, but you need to modify\add some code.
when I click on Insert Picture, It is not taking any action but when I check vba code then it shows error on line no. 6 & showing range error.
I am calling cheques as I have needed from folder but 1 thing more if my pictures are in jpeg, jpg, png or other format so how can I call
Kindly suggest me on both my queries.
Thanks
this is really good thing to save time. But when I tried it I got a dialogue box of RUN TIME ERROR " Unable to get the insert property of the picture class" but when I changed my pictures name from IMG_20200815_085825 to any word name it will work. Can you help me to work this without changing my pictures name??
thank you sir, how about deleting the picture?
Hi, Can you help me to unlink the image path of the inserted image by VBA code in excel and save image in the same cell by VBA please. so that I can send the file to others.
I hope, when you send the file to anyone, it does not give link or path.
Sir I have morethan 50 photos so how can change all the name at same time instead of individually one by one please guide me sir
VBA the "i" is showing as red(wrong)= i am using B3 as name and picture location as B135. Can you advice
I have replied to your email, hoping that would be helpful for you.
Hi how can do
Sir plz guide me
Where i make change in code
I have a request to send with following scenario.
If the Name of Animal is a merged cell then how we can insert the picture with the help of VBA.
how to fix the run time error 1004. unable to get the insert property of the picture class.
Hi i am get error the "Set animal_pic = ActiveSheet.Pictures.insert(pic_location)" Run-time error "1004": Unable to get the Insert property of the Picture class
Were you able to fix it? i have the same error
its not working i m getting this error RUN TIME ERROR " Unable to get the insert property of the picture class"
Same
Bro I am pulling data from nse website option chain I want first highest second highest oi data paste into another sheet how to do that and sheet is refreshing automatically 5 minutes and ever time data come in new row
I can automate your data analysis for NSE data. Send me email at Exceldestination@gmail.com.
Bhi ye quiery bahut demand m h
Sir mene sheet bana le h Pr ose automate karna h matlab vo sheet har 8 min p auto refresh ho ke save ho Jai
For a code that works correctly if the direction of the paper is from the left. And it's wrong if the direction of the paper is from the right... How to make the image appear in its correct place if the direction of the paper is from the right
Thanks sir... but i m getting debug here
Set stpic = ActiveSheet.Pictures.Insert(piclocation).. i m gett
send me your file at exceldestination@gmail.com let me check
Mail sent and Thank you sir for quick response..
Awaiting reply sir
Hi sir
If i want to assign pic location address into worksheet cell
yes, that can be done easily
@@ExcelDestination
This one want to do plz share code
Sir when I clicking insert am getting error message 1004 unable to insert picture class. Pls help how to solve this.
without looking code, not sure.
@@ExcelDestination mail id pls
Sir . Also error of unable to get insert property in picture class comes when we select one item. Ie, picture against one item. Pls help to solve this also. If all 5 items we select them no error
Sir,hope you receive my mail
Very helpful...
I like your videos....
I have one query that I m working in HR department...I need to send 30 to 40 mails daily using Gmail account ...will you make video for sending emails using Excel VBA via Gmail instead of outlook...
Please help me..it will save my time...
Sure, I will create that.
Thank you very much for your favourable reply....
Unable to get the insert property of the picture class
not sure. It is standard property in excel.
I need same VBA code in note ,
insert of picture can we get pdf file
الكود يعمل بشكل صحيح اذا كان اتجاه الورقة من اليسار ..ويخطا اذا كان اتجاة الورقة من اليمين...كيف يمكن جعل الصورة تظهر في مكانها الصحيح اذا كان اتجاه الورقة من اليمين
could you please send the code
This code only adds a single image
why not copy code and pin below video ?
mine presents this error here:
it is not possible to obtain the insert property of the pictures class
without looking at your code, not sure what is the error. you can send me your file, I can check and let you know. If you need my file, send me email at exceldestination@gmail.com I will provide you the original file, which is working perfectly. Hope this helps!!!
@@ExcelDestination Mail sent and Thank
I sent you a file, because mine gave error in the Pictures Class. Make your file available for us to download and actually see what's going on
Bhi live chat kaha p hoge plz reply
Live Chat is available on demand basis :)
not working for 2013
Sir. may you share with me the vba code?
send me email at exceldestination@gmail.com , Let me check, if I have the original file with me. I will send that to you.
Hello sir answer plz
hi
@@ExcelDestination
Plz share source code
I have tried it but after writing the code when I go to Sheet and click over it that returns error of not assigning Function or Sub. Could u pls tell me why I am having this issue/
without looking at entire code, I can not say anything. I guess, there could be typing mistake in function name.
@@ExcelDestination Do u have any tutorial regarding VBA active X control using or assigning function properly?