Excel Forum

JPG file set height & width

AlanCannon44

New Member

Members

Forum Posts: 1

Member Since:
December 22, 2016

Offline

June 1, 2024 - 7:41 am

I have been unable to find or create a macro that will adjust the height and width of an unopened jpg file. I found lots that will read the dimensions as 800 x 600 for example, but nothing that will set the height and width to a given size.

I have a number of jpg files in a directory of just jpg's which I use as the source for the windows background. Many of them are larger than what I want to avoid being partially hidden by my taskbar, etc. I want the macro to read the height of each file, and if it's more than 980 pixels then resize the file dimensions proportionally to set the height to 980.

Any help will be greatly appreciated.

Retired Molechaser

See Answer