Batch Resize Images In Folder

[J.Green]

I am unable to locate anything that is helpful to my needs.

Looking for a macro that uses the FileDialog to select a Folder containing images only.

The macro will resize all images in that folder to a specified size of Height and Width.

Does anyone have a resource or example macro that will accomplish this task ?

Thank you in advance.

[WideBoyDixon]

Try this: https://msaccessgurus.com/VBA/Code/W...zeImage_GG.htm

WBD

[J.Green]

WideBoyDixon:

Thank you for the resource.

It hard codes the location of the directories used for saving. Can you provide an example using the SaveFileDialog so the user to dynamically select the folder ?

Thank you !

[J.Green]

Please disregard my request.

After 14 hours of searching and trying different online macros I have decided it is not possible to do a batch resizing of images using VBA.
This type effort is better left to other means not involving VBA and Excel.

Thank you to all who read my post.

Cheers !

[WideBoyDixon]

Please Login or Register  to view this content.

Change the red lines to be your desired image size.

WBD