vba to crop a picture

  • Thread starter Thread starter Southern at Heart
  • Start date Start date
S

Southern at Heart

Is it possible to crop 44 pixels off the bottom of the .gif image MyPicture
located at the location MyLocation, and resave it as MyPicture?
 
On Fri, 26 Mar 2010 19:16:04 -0700, Southern at Heart

Not without a graphic library. Such third-party tool would have a help
file documenting how to do this.

-Tom.
Microsoft Access MVP
 
....I can do it manually with Microsoft Picture Manager. Is there a way to
call that program in vba?
 
On Fri, 26 Mar 2010 21:35:01 -0700, Southern at Heart

Not that I know of. Many programs don't expose an Automation
interface.

-Tom.
Microsoft Access MVP
 
http://www.imagemagick.org/script/index.php

I've never used it (have peeked, looks cool and quite useful), but I see
this recommended often. You can programmatically edit pictures in VBA by
shelling out commands. There's tons of help and discussion scattered across
google for various topics (while searching for the site Resize was the second
popdown in the list).

hth

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
With all due respect, the question was about MICROSOFT ACCESS, not Word. The code shown on that page will not work in Access.

(Just a note to others who might stumble upon this page...)
 
Back
Top