Forum

JPG file set height...
 
Notifications
Clear all

JPG file set height & width

2 Posts
2 Users
0 Reactions
182 Views
(@alancannon44)
Posts: 3
Active Member
Topic starter
 

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

 
Posted : 01/06/2024 5:41 pm
(@keebellah)
Posts: 373
Reputable Member
 

I think you should try use vb scripts instead of Excel VBA.

I use vbsedit for many tasks, the code is Visual Basic and you can do much more.

VbsEdit - VBScript Editor with Debugger

 
Posted : 02/06/2024 2:00 am
Share: