vba to crop a picture

[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?

 

[Tom van Stiphout]

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

 

[Southern at Heart]

....I can do it manually with Microsoft Picture Manager. Is there a way to
call that program in vba?

 

[Tom van Stiphout]

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

 

[Jack Leach]

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)

 

[Celad]

Yes, you can, directly in code.

Check out the following:
http://msgroups.net/microsoft.public.word.docmanagement/Can-I-create-a-macro-to-crop-a-picture

 

[Waldo Presley]

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...)