I wrote a VFP 9.0 program to automate Excel 2010. My program correctly imports JPG's into the spreadsheet, but the spreadsheet becomes too large. I can manually compress the JPG's by selecting one on each worksheet (there are 3 sheets), and clicking Picture Tools Format:Compress Pictures, then unchecking "Apply only to this picture" and selecting "E-mail (96 ppi)". However, I would like to do this programmatically, instead. Does anybody know how to do this?

Jerry