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

I have been working on a macro that automates the import of pictures (png) into a excel workbook. I am using Excel 2010. I am searched on the internet and can't seem to find a real answer as to why the error in my subject line is occuring. My code is simple - I hope it is a simple answer!

Please Login or Register  to view this content.

The ultimate goal of this macro is not just to import the pictures in - but to also name them consistently (once in the activesheet). Excel gives them random names "Picture 24372", etc. I want to have the name of the picture be the same as the filename (minus the *.png).

Thank you!

Thanks for your help! i got it solved. You were correct. Also discovered that Excel 2010 only puts in links using that - so I am using ActiveSheet.Shapes.AddPicture to embed the images.