Tag Archives: WIA

Creating a VBA WIA Image Manipulation Class Module

Over the years, I’ve published numerous articles about 1 off WIA functions:

VBA - WIA - Rotate an Image

... This simple function now empowers us to be able to integrate image manipulations such as rotation within any Access solution (Word, Excel, PowerPoint,…

VBA - WIA - Resize/Scale an Image

How to Crop an Image Using WIA in VBA

I’ve previously published several articles about manipulating images with VBA, things like: Recently, I had someone ask me: Short answer, of course!

VBA – WIA – Flip an Image

I was helping out in a forum discussion regarding manipulating images, specifically flipping them and published some of my code there, so I thought I’d share it here for everyone else to benefit from. Once again, WIA has everything we need to quickly and easily perform this task! WIA offers developers 2 image processing properties: FlipHorizontal and FlipVertical that we need only apply. Below are a few sample functions illustrating how it can easily be implemented.

and many others.

I decided that I explore taking all of these functions and transform them into a Class module.

Continue reading →

Auto Orienting Images via VBA

Have you ever loaded an image into say an Access Image control, or ‘legacy’ Web Browser control, only to have the image display flipped and/or rotated like:

when if you open it in most image software, preview it in explorer, open it in most modern day web browsers it displays just fine like:

and wondered what was going on exactly.

This happens because of something called the Exif Orientation tag, which is a piece of metadata stored inside many JPEG images by cameras.

Basically, when you take a photo, your camera records how you were holding the device (upright, sideways, upside down, etc.) and saves this information in the Exif Orientation tag (this is hidden information that is stored with the image). Instead of actually rotating the pixels in the image file, the camera just notes the orientation in the metadata. Some programs, like Windows Explorer, read this tag and automatically display the image in the correct orientation. Other programs might ignore the Exif Orientation tag and show the image as it is physically stored, which can result in the image appearing sideways or upside down

Continue reading →

Convert Any Angle Into A Cardinal Angle => 0, 90, 180 and 270

While working on the same project in which I came to need:

Convert Any Angle Into A Positive Angle Between 0 and 359

Working on a personal project, I was in need of allowing the user to enter a rotation angle. I wanted to allow the user to make any entry, but the code that performs the rotation only accepts positive angles, so it became necessary to create a simple little function to perform a conversion of the input (so any value) and output a controlled value between 0 and 359 degrees.

I perfected the function to actually output cardinal angle since my actual need was to produce angles to work with WIA’s rotate filter.

So I was after cardinal value like: 0, 90, 180, 270.

Continue reading →

VBA – WIA – Check If A File Is In An Acceptable Format

Over the years, I’ve released a number of posts and functions for working with images using WIA:

VBA – WIA – Convert Image to Grayscale

Today, I thought I’d add to my library of image manipulation functions and I set out to see if there was a way, using WIA (Microsoft Windows Image Acquisition Library), to convert an image to black and white, well to be more precise to convert it to grayscale. I originally searched high and low and…

Reading A Specific Exif Property with WIA