Need to create macro for inserting a picture, resizing and compressing it. I have recorded a simple macro using mouse clicks and it works, however the compressed size of the file (workbook) is 30% larger than when I complete this process manually. For some reason it appears to be the difference in macro compression as the other steps don't show a significant size difference in the completed file.
I want to automate these steps - import > picture > from file > resize by dragging corner handle with mouse > right click > properties > format > compress picture (.jpeg from 640x480 to thumbnail).

Anyone able to help please ?