>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.
You can use GDIPlusX to compress the image file inside VFP. Check
http://vfpx.codeplex.com/wikipage?title=GDIPlusX&referringTitle=Home and
http://weblogs.foxite.com/vfpimaging/2012/03/16/resizing-images-with-gdiplusx/For more samples, I encourage you to Google "GDIPlusX resize"