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).