Forum Discussion

seanmccole's avatar
seanmccole
Copper Contributor
Feb 17, 2022
Solved

Create a macro to crop images

Hi,   I'm trying to create a macro to crop an image to 1:1 ratio but I'm not sure if its possible.  I'm constantly cropping images and resizing them and it would unbelievably benefit my workflow i...
office 365
  • Doug_Robbins_Word_MVP's avatar
    Doug_Robbins_Word_MVP
    Feb 20, 2022

    seanmccole The information on using those properties is pretty sparse, but after a few attempts, I believe the applicable property is the .PictureFormat.Crop.PictureOffsetX and that the offset is from the center of the picture.  For the result that you want, probably no offset is required.

     

    Using the following code with an image that was distorted to the size of your image:

     

    With ActiveDocument
        For i = 1 To .InlineShapes.Count
           With .InlineShapes(i)
               .PictureFormat.Crop.ShapeWidth = .Height
               .PictureFormat.Crop.ShapeHeight = .Height
               .PictureFormat.Crop.PictureOffsetY = 0
               .PictureFormat.Crop.PictureOffsetX = 0
           End With
        Next i
    End With

     

    the result shown compared to an uncropped version of the image

    Increasing the offset, by using

    .PictureFormat.Crop.PictureOffsetX = 10

    reduces the crop from the left

    and reducing it by using

    .PictureFormat.Crop.PictureOffsetX = -10

    increases the crop from the left

     

     

     

     

opticswhiz's avatar
opticswhiz
Copper Contributor
Jul 07, 2023

Hi Sean, I am Yousuf from https://opticswhiz.com/

Yes, it is definitely possible to create a macro to crop an image to a 1:1 ratio. You can automate this process to save time and improve your workflow. Here's a general outline of the steps you can follow to create such a macro:

Identify the software you are using to perform the image cropping and resizing. Macros can be created in various applications such as Photoshop, GIMP, or Microsoft Office applications like Excel or Word.

Determine the specific programming or scripting language that the macro will use. For example, if you are working with Excel, you can create a VBA (Visual Basic for Applications) macro. If you are using image editing software like Photoshop or GIMP, you may need to use a scripting language specific to that software (e.g., JavaScript for Photoshop).

Learn the basic syntax and commands for the chosen language. This will allow you to write the necessary code for cropping and resizing images.

Write the macro code that performs the desired cropping and resizing operations. The exact code will depend on the software and language you are using. However, here's a general approach you can follow:

a. Open the image file.
b. Determine the original dimensions of the image.
c. Calculate the dimensions for the 1:1 crop. You can choose the shorter side of the image as the reference and crop a square from there.
d. Crop the image using the calculated dimensions.
e. Resize the cropped image to the desired size, if necessary.
f. Save the modified image.

Test your macro with a sample image to ensure it works as expected. Make any necessary adjustments to the code if needed.

Apply the macro to your entire image collection or automate it to process multiple images in a batch. This will save you time and effort.

Remember, the specific details of creating a macro will vary depending on the software and language you're using, so it's important to consult the documentation or resources specific to your chosen tools.

Resources