[Help] Run-time error '1004': Unable to get the Insert property of the Pictures class

I am having problems running this code for displaying pictures in excel. I am a beginner, so I must be doing something wrong. When I run it I get the message "Run-time error '1004': Unable to get the Insert property of the Pictures class". When I depurate, excel marks this line that says: "With image_column.Worksheet.Pictures.Insert(url_column.Cells(i).Value)"

This is the code:

Please Login or Register  to view this content.

My excel file looks like this
\1



I have tried also another code for importing the pictures and display them. I created the folder IMAGENES EXCEL in C:
When I run it, I get the same error. and when I depurate I get this line marked: "With ActiveSheet.Pictures.Insert(PicPath & IconName & "1" & ".jpg")".

Please Login or Register  to view this content.

If anyone could help me I would be very grateful.

: ) Sixthsense : ) , thank you very much for your help, I have tried to change that line, and still I got the same problem.

Pls check the file name in the path

Sorry, which file name? Do I have to give a name? Where do I have to write it? Do I have to select any column? Is excel going to know it is my column A the one who has the url? Thank you in advance.

You have variable named as IconName, Is it a folderName in your PC or is it Picture Name?

If it is folderName that you need to add "\" after it.

Paresh J, Thank you very much for your help. Sorry, I don't understand. I have found this code on internet so it is not mine. I think I have to give excel a folder and a file name for saving the pictures... exactly where do I have to write it? The folder is PicPath, and file name is it Total? Sorry, I am very beginner with this. Thank you in advance.

Sorry, It is not solved yet.

Thank you very much. I have solved it adding a file with the name Total1.jpg to the folder. But that is not what I wanted... I wanted to download and display the pictures.
What I wanted to do was what the first code I wrote does. I have been able to run it, and now I don't have the 1004 error. But after loading 2 pictures, I get a Microsoft Visual Basic "400" error, and doesn't keep downloading the next picture, the third one. I have attached the excel file. Thank you for helping me.Thumbnails Excel.xlsm

Please Login or Register  to view this content.