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, and clicking Picture Tools-Format:Compress Pictures, then unchecking "Apply only to this picture" and selecting "E-mail (96 ppi)". However, I want to do this programmatically. Does anybody know how FoxPro can get the Excel Object Model to compress pictures in a spreadsheet?

Jerry

PS: Doing it while creating an Excel macro yields no VBA code.